Thursday, 9 July 2020

Types of SQL Server Backups

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:


  • Full backups
  • Differential backups
  • File backups
  • Filegroup backups
  • Partial backups
  • Copy-Only backups
  • Mirror backups
  • Transaction log backups

Types of SQL Server Backups

Overview SQL Server offers many options for  creating backups.  In a previous topic, Recovery Models, we discussed what types of backups c...