Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server Restoring Sequence
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

9 Posts

Posted - 07/11/2012 :  23:46:37  Show Profile  Reply with Quote
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,


Starting Member

1 Posts

Posted - 07/12/2012 :  00:47:04  Show Profile  Reply with Quote
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

Go to Top of Page

Starting Member

9 Posts

Posted - 07/12/2012 :  06:10:38  Show Profile  Reply with Quote
thanks a lot.

Go to Top of Page

Aged Yak Warrior

885 Posts

Posted - 07/12/2012 :  11:07:08  Show Profile  Visit lionofdezert's Homepage  Send lionofdezert a Yahoo! Message  Reply with Quote
Why you donot like to use a simple but really effective stored procedure suggested by Michael Valentine Jones

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000