Restoring Backup

Question

Restoring Backup

poratips

Hall of Fame

Points: 3994
More actions
May 21, 2013 at 10:04 pm

#275380

Hello,
I would like to know that what will be the best way to restore from Full backup, Differential and Transaction Log back up?
We are taking weekly Full backup, Daily Differential and every hour T-Log back up into Sql server 2008.
Thanks,

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Andrew G SSChampion Points: 12809 More actions · Answer 1

You need to restore the FULL backup first WITH NORECOVERY, then the latest DIFFERENTIAL backup WITH NORECOVERY, then all the log backups starting from the last differential to the last log backup WITH NORECOVERY, then WITH RECOVERY on the last restore command.

http://msdn.microsoft.com/en-us/library/ms177429.aspx

poratips Hall of Fame Points: 3994 More actions · Answer 2

poratips

Hall of Fame

Points: 3994

May 27, 2013 at 3:09 pm

#1618823

Thanks

poratips Hall of Fame Points: 3994 More actions · Answer 3

Do I need to do anything with schema or user login or just restore will work?

Andrew G SSChampion Points: 12809 More actions · Answer 4

If moving to a different server, you need to script out the original server logins. You can use Microsoft stored procedure to do that http://support.microsoft.com/kb/918992

Kingston Dhasian SSCoach Points: 19799 More actions · Answer 5

There is a book on Backup and Restore by Shawn McGehee

http://www.sqlservercentral.com/articles/books/89519/

Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/

poratips Hall of Fame Points: 3994 More actions · Answer 6

poratips

Hall of Fame

Points: 3994

July 15, 2013 at 6:32 am

#1632438

Thanks, I have downloaded the login script.