Tag Tutorial – SQL Server Backup Tutorial

Learn about filegroup backups for a database. This covers what a filegroup backup is and when and how to create.

Learn about partial backups, what they are and how to create a partial database backup in SQL Server.

Learn how to create a backup using the SSMS interface and options.

Learn how to create a backup using T-SQL code.

Learn about different ways to create a database backup.

This section covers different options that can be used when creating a transaction log backup along with many examples.

Learn about different options that can be used when creating a full database backup with several examples.

This section goes a bit deeper into the use of backup database and backup log commands.

In this section we cover what file backups are for a SQL Server database and when and how to create them.

Learn how to create differential backups to capture only the most recent changes since the last full backup.

This section covers different ways to create transaction log backups for a SQL Server database.

In this section we cover how to create full database backups using either the SSMS GUI or using T-SQL code.

The bulk logged recovery model let you minimize the use of the transaction log and allows for several types of database backups.

The simple recovery model allows you to still take full database backups, but minimizes the use of the transacation log and does not allow transaction log backups.

The full recovery model allows you to perform any type of backup on a SQL Server database such as full, transaction log, differential and more.

In this section we look at the different recovery models for databases and how this impacts the types of database backups.