Solved

Need advice on create a DR plan for SQL Server

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

Accepted Solution

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

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:jrsitman
ID: 36893237
Thanks. Very helpful
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now