Overview
SQL Server offers many options for creating backups. In a previous topic, Recovery Models, we discussed what types of backups can be performed based on the recovery model of the database. In this section we will talk about each of these backup options and how to perform these backups using SSMS and T-SQL.
Explanation
We will cover the different types of backups that can be created in SQL Server.
Different types of SQL Server backups you can create:
- Full backups
- Differential backups
- File backups
- Filegroup backups
- Partial backups
- Copy-Only backups
- Mirror backups
- Transaction log backups
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.
