Different Types of SQL Server Backups
SQL Server supports different types of backups for databases. However, which type of a database backup can be performed totally depends upon the recovery model of the database one choose. If you are unclear of the advantages and disadvantages of each recovery model then we would recommend you to read about SIMPLE, FULL and BULK-LOGGED first.
In this tutorial we will discuss in detail different types of SQL Server backups which are available and how to perform backups using TSQL scripts and by using SQL Server Management Studio (SSMS).
Different Types of SQL Server Backups you can create are:-
- Full Backup
- Differential Backup
- Transaction Log Backup
- File Backup
- FileGroup Backup
- Partial Backup
- Copy-Only Backup
- Mirror Backup