Solved

Need advice on create a DR plan for SQL Server

Posted on 2011-09-26
3
132 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 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

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…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

635 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