Need DR failover plan documentation

Posted on 2009-06-29
Medium Priority
Last Modified: 2012-06-27
I have the tecdhnical details of a MSSQL disaster recovery failover plan documented. What I need to find is an example of the verbage to write up the plan. I have drawings and all the technical information but I have never written one of these before and my boss has told me to write up the pllan por publication to the company.

any suggestions would be appreciated.
Question by:jimmylew52
LVL 43

Accepted Solution

Eugene Z earned 2000 total points
ID: 24747257
check solutions
Disaster Recovery and Backup Plan Document
SQL Server Disaster Recovery Planning and Testing
LVL 38

Expert Comment

by:Jim P.
ID: 24747706
Really it is a matter of creating a checklist of all the steps you would have to take to go from zero to go for release to users.

Some of the things to think of:

Is it going to be a scratch built server? Or do you have one in place that you are attaching or restoring too?

Who is going to be doing the restore -- you? Joe the service desk guy hired two days ago? Some technical contractor? A DBA? (And at what level do you have to write instructions?)

How much can be done as prior planning?

The best way is to just walk through the whole process and take many notes. Or if you can do it, have someone else walk through from your instructions and see if it makes sense to them.

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question