Solved

Need advice on create a DR plan for SQL Server

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

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…
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

739 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