Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am DBA of a big online retail company. I am responsible for the availability of the company’s database. The size of this database is 28GB, and it handles an average of 120 transactions every minute. my main concern is to minimize the time required to restore the database in case of a failure.

Describe the backup strategy that you will use.

share|improve this question

migrated from stackoverflow.com Jan 11 '11 at 18:39

This question came from our site for professional and enthusiast programmers.

    
"describe the backup strategy that you will use." You mean you're the DBA or we're the DBA? The wording sounds kind of like it's from a third-party than yourself. –  Bart Silverstrim Jan 11 '11 at 19:22
    
Well for a start you don't think about just "backup strategy" to support a database that large and heavily used, you need to bake in resiliency from day one of the design. Rather than trying to make the time to backup one database as small as possible, you perhaps might start by deciding how long it can be offline for in a disaster and work backwards from that. –  RobM Jan 11 '11 at 19:25
5  
Homework question? –  Chris S Jan 11 '11 at 19:26
2  
Sounds like homework to me. If the OP were actually the DBA of a big online retail comany he would probably already know the answer. –  joeqwerty Jan 11 '11 at 19:35
1  
@Chopper3, buying something with user ";drop *; might be more interesting. –  Chris S Jan 12 '11 at 14:19

2 Answers 2

My strategy would include:

  • Implementing a Active-Passive Cluster
  • Bare Metal Recovery Backups
  • A warm-site spare if downtime costs justified it
share|improve this answer
    
Seems like you'd also want to just backup the DB. So you could do a DB level restore as well as file level restore, if you needed to. –  JamesBarnett Jan 11 '11 at 19:51
    
@James, the answer was intentionally as vague/non-comprehensive as the question. But a good point none the less. –  Chris S Jan 11 '11 at 19:59
    
Bare Metal Recovery should imply backups - otherwise, you don't have anything to recover from. That said, it's a very good point that HA and DR are not backups. –  mfinni Jan 11 '11 at 20:06

Consider Microsoft System Center Data Protection Manager and maybe some training in this, or other, area.

share|improve this answer
    
What OS is the database running on...? –  Bart Silverstrim Jan 11 '11 at 19:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.