I have been tasked with creating a document for the testing of our DR/BC Plan for our SQL Servers. We are using DB Mirroring (tier-1) and transaction log shipping (tier-2) and for tier-3 databases we will rely on nightly backups to restore too (non-critical DB's with little to none data changes).
What I am interested in is getting ideas on what should be in the document for testing the plan, I am wanting an accurate an detailed document that will test as many feasable scenarios as possible.
What I need to cover is the scenarios to test the three tiers (with more focus being on the top two tiers), which has very detailed step by step instructions on how to complete the scenario.
I have never done a document like this and would be interested in other peoples thoughts and experience.
- Is there examples for this type of document that I can look at?
- Has anyone had any experience in creating a document like this that would be happy to share thoughts and touch on what they included in there plan?
I have done application test cases before, do I aim for a document that is similar to a test case whereby an explanation of what you want to achieve and the steps that you do including specifying what gets typed, or should it be a more open document allowing the user to push the boundaries a little?
AS this is my first attempt and my searches on the internet hasnt returned much that is of any assistance, my appologies if I have upset anyone with silly questions or incorrect use of terminology, your guidance and corrections is appreciated.
Update: Basically, I am seeking any ideas or input into the best way to structure a SQL Server DR/BC Test failover plan to enable myself or others in the organisation to test our plans to ensure they work as intended. If anyone knows of any good resources they can direct me to it would be greatly appreciated.