Overview
One of your last lines of defense for just about any system is to have a backup in place in case there is a need to recover some or all of your data. This is also true for SQL Server.
Explanation
In this tutorial, we will discuss:
- Selecting the correct recovery models
- What backup options are available
- How to create backups using T-SQL commands and SQL Server Management Studio
If you are new to SQL Server, you should review each of these topics, so you are aware of the available options and what steps you will need to take in order to recover your data if ever there is a need.
You can either use the outline on the left or click on the arrows at the top or the bottom of each topic.
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.
