Everything Happens By Mistake
Jul 26, 2010
Restoring Deferential backups in SQL Server
id you have ever restored a SQL data base? If you are a developer probably not. With this post I'm going to show how to restore deferential backups step by step.
One important thing, to restore deferential backups, you need to have latest full backup and subsequent deferential backups.
Go to the SQL Server Management Studio, and select
option by right clicking on
node in the Object Explorer. Follow the steps as shown in following screen shot.
from the left of the dialog and select the following option.
Now, note your data base's status has been changed to
Restore the number of subsequent deferential backups,
except the last one
, only with "
RESTORE WITH NORECOVERY
" option on.
Restore last backup with default values of the option dialog box. That is with "
RESTORE WITH RECOVERY
" option. And also note the database status has changed back to normal.
This demonstration was done with SQL Server 2005 with SP2
Adhere necessary procedures with you company if you are going touch live data base.
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)