SQL Server Restoring Sequence - SQL Server Forums

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

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

SQL Server Restoring Sequence

Author

Topic

satya.katari89
Starting Member

9 Posts

Posted - 2012-07-11 : 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 Post

Posted - 2012-07-12 : 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

9 Posts

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

thanks a lot.

-Satya

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-07-12 : 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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources