SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
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 Previous Topic Topic Next Topic  

satya.katari89
Starting Member

India
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,
satya






-Satya

mkyatham
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

Done!!
Go to Top of Page

satya.katari89
Starting Member

India
9 Posts

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

-Satya
Go to Top of Page

lionofdezert
Aged Yak Warrior

Pakistan
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
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=148377

--------------------------
http://connectsql.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.09 seconds. Powered By: Snitz Forums 2000