SQLTeam.com | Weblogs | Forums

Whether the full backup includes log backup?

sql2008

#1

Hi,

In SQL Server, whether the full backup of a database
includes the backup of the log? Thanks


#2

A full backup includes parts of the log records, but only those parts that are required to enable SQL Server to restore the database to a consistent state. During restore, SQL Server goes through an "undo" phase and "redo" phase. In the undo phase SQL Server rolls back any transactions that have not yet been committed, and in the redo phase, it saves the changes of all committed transactions stored in the log portion, but not yet written to the data file.

If you are in full or bulk-logged recovery model, doing a full backup does not clear the log file. You have to do a log backup for that.


#3

No. Database and log backups are completely separate tasks, and do not affect each other directly.