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
The different types of backups that you can create are as follows:
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
The different types of backups that you can create are as follows:
- Full backups
- Differential backups
- File backups
- Filegroup backups
- Partial backups
- Copy-Only backups
- Mirror backups
- Transaction log backups
