Overview
What good is a backup if you do not know how 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.
Explanation
As you will see, many options 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.
Greg Robidoux has been working with databases for 35+ years with extensive hands on SQL Server experience from version 6.5 to 2025. He has authored over 250 technical articles and delivered several presentations online and at various conventions. Greg is also the President and founder of Edgewood Solutions, a technology services company delivering services and solutions for Microsoft SQL Server.
