Solved

Need advice on create a DR plan for SQL Server

Posted on 2011-09-26
3
129 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
3 Comments
 
LVL 8

Accepted Solution

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

Assisted Solution

by:lcohan
lcohan earned 250 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

685 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