By: Greg Robidoux
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
