?
Solved

Need advice on create a DR plan for SQL Server

Posted on 2011-09-26
3
Medium Priority
?
134 Views
Last Modified: 2012-05-12
We currently have 1 SQL 2008 Management Studio.  Let me first state I'm not SQL trained other than minimum knowledge.  What I'm looking for is advice on what to do to prepare for disaster.  If our SQL server crashes, how do I ensure that I have a plan in place to get us back up and running on another server ASAP.  I do realize that all the programs using SQL will have to be redirected to the new server.  I just want help creating a plan to insure we are as prepared as possible recover what was on the server.
0
Comment
Question by:J.R. Sitman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 8

Accepted Solution

by:
venk_r earned 1000 total points
ID: 36601528
0
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 1000 total points
ID: 36710425
I think you should build your Disaster Recovery plan based on your business needs - just ask yor busines:
1. how much data loss can we afford? (most cases the answer will be "notihng" or no data loss)
2. how much time the system(s) running against SQL2008 DBs can be down? (depending of the busines nature this varies from very little to few hours/day(s))

Regardless of your DR planning you must have DB maintenance, Backups, and eventualy a StandBy server if your busines runs 24/7 with no down time (like a e-commerce web site for instance)

Please see details about "How to: Set Up, Maintain, and Bring Online a Warm Standby Server"at:

http://msdn.microsoft.com/en-us/library/ms178034.aspx
0
 

Author Closing Comment

by:J.R. Sitman
ID: 36893237
Thanks. Very helpful
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

719 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