July 29, 2009 at 4:17 am
If we take full dababase backup then is log is also backed up and truncated as it happens in log backup? I think NO. ANy Headsup!!
-Lucky
July 29, 2009 at 4:37 am
Although the transaction log is included in the full backup, the log is NOT truncated.
If it was, the chain of log backups would be broken by the full backup, and you wouldn't be able to do an up to date restore from an earlier full backup.
July 29, 2009 at 6:31 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply