SQL Server 2017 Administrator's Guide
上QQ阅读APP看书,第一时间看更新

Backup types

SQL server supports three main types of backup:

  • Full backup
  • Differential backup
  • Transaction log backup

Each of these types has several variants and we will go through each of them.