Full backup

A full backup is simply the backup of a complete database. When performing a full backup, SQL Server stores metadata of the database (its name, creation date, all options set to the database, paths to all files belonging to the database, and so on), used data pages of every data file, and also the active part of the transaction log (which means all transactions that are not checkpoint yet and all running transactions even if they are not finished).

At the end of the backup process, SQL Server stores the last Log Sequence Number (LSN) for possible additional backups.

A full backup never clears the transaction log file!

A full backup can be performed with no respect to the recovery model set but the correct option is to have a ...

Get SQL Server 2017 Administrator's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.