SQL Server Forums - SQL Server Restoring Sequence

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

SQL Server Restoring Sequence

New Topic

Reply to Topic

Printer Friendly

Author

Topic

satya.katari89
Starting Member

India
6 Posts

Posted - 07/11/2012 : 23:46:37

Dear All,

please answer my Question i have lot of confusion in database recovery.

suppose i have,

full backup of sql server : 08: 00 AM

transaction log : 09:00 AM
Differential : 10:00AM
Transaction : 10:30 AM
Differential : 11:00 AM
Transaction : 11:15 AM

my database got corrupted at 11:50 AM..

how do i retrieve my database, please give me the sequence.

thanks & Regards,
satya

-Satya

mkyatham
Starting Member

1 Posts

Posted - 07/12/2012 : 00:47:04

1. First try to get the tail backup of the log if available with No Truncate option.
2. Restore the Latest full back up( 8:00 AM) WITH NO RECOVERY
3. Restore the latest differential backup( 11:00 AM) WITH NO RECOVERY
4. Restore all the Transactional backups taken after the latest differential backup. In this scenario restore the Transactional log backup taken @ 11:15 AM WITH NO RECOVERY
5. Restore the Tail backup WITH RECOVERY

Done!!

satya.katari89
Starting Member

India
6 Posts

Posted - 07/12/2012 : 06:10:38

thanks a lot.

-Satya

lionofdezert
Aged Yak Warrior

Pakistan
864 Posts

Posted - 07/12/2012 : 11:07:08

Why you donot like to use a simple but really effective stored procedure suggested by Michael Valentine Jones
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=148377

--------------------------
http://connectsql.blogspot.com/

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.