The first step is to verify the backup. Use the RESTORE command to verify the contents of the backup. There are certain arguments that can be used with the RESTORE command. The RESTORE FILELISTONLY lists the database and log files contained in the backup set.
I also find the RESTORE VERIFYONLY very useful to check if the backup set is complete and the entire backup is readable.
You can read more about the other RESTORE Arguments over here.
Once we have verified the back up, we can now go ahead and restore the Full and Differential Backup using the following T-SQL
In a similar manner, you can even restore a transactions log backup.
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|