Types of SQL Server Backups

OverviewSQL 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.
ExplanationThe 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