SQL Server supports three main types of backups: full, differential, and transaction log. A full backup copies the entire database and its metadata, and it is the base for restoring the database.