SQL DBA?

Question

hi.,

My Question is

My Database size is 1 terabyte,

Fullback every sunday

Differential Backup every 6 hours

Transactional  log back up every 15 mints

My Database is Wednesday 9.30 Am Crashed.How will recover & What are the steps?

Please tell me.

Answer 1

Hello,

The basic outline for this would be full->latest diff->all tran logs.

1. Backup the tail of the log if possible.

2. Restore the latest full backup with no recovery

3. Restore the latest differential with no recovery

4. Restore all log files from the differential time period to the last log file (not counting the tail backup taken) with no recovery

5. Restore the tail of teh log backup taken with recovery

-Sean

---

Sean Gallardy | Blog | Twitter

Answer 2

Here are some additional thoughts:

http://www.karaszi.com/SQLServer/info_minimizing_data_loss.asp

http://sqlblog.com/blogs/tibor_karaszi/archive/2010/03/27/restore-database-to-the-point-of-disaster.aspx

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 3

thanks.,

give me timing details please sean Gallardy

Full Bcakup

Differential backup

Logbackup must

Thanks

Answer 4

1. restore fullbackup with no recovery
2. Restore very last Diff backup b4 the crash  with no recovery  
3. Restore all log backup after the very last Diff backup with no recovery( up to 9.00)
4.  if DB cashed at 9.30 i assume you may not have 9.30 backup then Restore the very last backup (backup @9.15) with recovery   

Hope this helps

---

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 5

The first step should ALWAYS be to attempt a tail of the log backup before restoring over a database if applicable.

-Sean

---

Sean Gallardy | Blog | Twitter

Answer 6

hi sean .,

Can u specific time for senario please

Answer 7

Restore timing strongly depends on your hardware : storage, network, tape, etc.

You'll have to test it on your own servers.

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu