May 21, 2013 at 10:04 pm
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,
May 22, 2013 at 1:11 am
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.
May 27, 2013 at 3:09 pm
Thanks
May 27, 2013 at 3:09 pm
Do I need to do anything with schema or user login or just restore will work?
May 27, 2013 at 4:37 pm
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
May 28, 2013 at 1:21 am
There is a book on Backup and Restore by Shawn McGehee
http://www.sqlservercentral.com/articles/books/89519/
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 15, 2013 at 6:32 am
Thanks, I have downloaded the login script.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply