December 5, 2010 at 2:32 pm
Hello All
We are a small company with the employees sharing a lot of responsibilities.
I am not an exception.
We are going to set up a SQL server 2008 environment. Now is the time to decide with back up plans and disaster recovery plans.
We are planning to interview each of the 10 departments we have to let them choose one of the three backup templates.
What is a back up template ?
[font="Comic Sans MS"]This is a back up plan indicating
how the databases are backed up ?
What kind of back ups ?
At what time of the week a Full DB back up is taken ?
At what time of the week backups are sent offsite?[/font]
The above set of questions are just as of my knowledge, i want you guys to add content/advices to this to make it complete or meaning full.
What am i trying to accomplish
I will interview each department (Finance, HR, Billing etc) and provide them with three such templates
1. Highly backed up / Highly available/Quick Restore Times
2. Moderately Backed up / Not so highly available/Fast Restore times
3. Normally backed up/ Compromising availability/Wait to get restored
Each department will pick a template suitable for them or We will decide looking ta their DB sizes n transactions, whether to allot Template1 or 2 or 3 for each department.
Please suggest.
:-)Thanks In Advance 🙂
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
December 5, 2010 at 2:40 pm
Too technical. Business users aren't going to understand the significance of the options. A finance person isn't going to have a clue how the databases should be backed up nor what kind of backups should be used, and he shouldn't, that's your job.
Two things you need from business users:
What's the downtime allowance for this database? How long can it be unavailable without impacting business and what kind of impact is there over that time.
What's the data loss allowance for this database? If there's a disaster how much data can be lost without causing a crisis.
Once you have those, consider what you can do with the hardware and resources available and come to a compromise and agreement with the departments.
You need to establish hard numbers. Otherwise, when there's a disaster you're going to have the finance person assuming that 'Highly backed up / Highly available/Quick Restore Times' means zero data loss and 5 minutes downtime when you thought it meant 15 minutes of data loss and an hour downtime.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 5, 2010 at 2:46 pm
Awesome. 🙂
I will keep the back up plans to myself,Instead i will approach them with Questions you mentioned.
Thanks a lot
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply