SQL Server Restore Tutorial


By:   |   Updated: 2011-06-07   |   Comments   |   Related: 1 | 2 | 3 | More > Restore

Read the tutorial!

What good is a backup if you do not know to restore the backup.  In this tutorial we will look at what restore options are available and which options are only accessible using T-SQL commands.

As you will see there are many options that can be used, but just like the BACKUP commands there are just a few parts of the RESTORE command that are needed to do a successful restore.

Take the time to review each of these topics to get a good understanding of what is available:

  • Restore commands
    • HEADERONLY
    • LABELONLY
    • FILELISTONLY
    • RESTORE DATABASE
    • RESTORE LOG
    • RESTORE VERIFYONLY
  • Restore options
    • WITH RECOVERY
    • WITH NORECOVERY
    • WITH STATS
    • WITH REPLACE
    • WITH MOVE
    • WITH STOPAT
  • Exclusive access

Read the tutorial!



Last Updated: 2011-06-07


get scripts

next tip button



About the author
MSSQLTips author Greg Robidoux Greg Robidoux is the President of Edgewood Solutions and a co-founder of MSSQLTips.com.

View all my tips




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download

























get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools