October 23, 2015 at 5:46 am
Hi,
In SQL Server, whether the full backup of a database includes the backup of the log? Thanks
October 23, 2015 at 5:49 am
Yes.
It doesn't truncate the log, only log backups do that (in full/bulk-logged), but full backups do back up a portion of the log. If they didn't, it would not be possible to restore a database to a consistent state.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2015 at 9:37 am
Just to clarify, a database backup does not fully back up the log. It gets only the active portion of the log necessary to bring that full backup to a usable state. Thus, one single full backup would not allow you to restore to different points in time. Full log backup is a completely separate task and process for SQL Server from database backup.
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply