Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Truncating Log During Backup Expand / Collapse
Posted Thursday, May 8, 2008 6:21 AM


Group: General Forum Members
Last Login: Monday, November 2, 2015 3:51 AM
Points: 133, Visits: 318
I don't think the following actually truncates the log... but can someone verify if it does or doesn't?

BACKUP DATABASE [databasename] TO DISK = N'D:\Backup Files\DATABASENAME.BAK' WITH INIT , NOUNLOAD , NAME = N'databasename backup', SKIP , STATS = 10, NOFORMAT


Post #497044
Posted Thursday, May 8, 2008 6:41 AM



Group: General Forum Members
Last Login: Today @ 1:56 PM
Points: 45,616, Visits: 44,144
Database backups do not truncate the trasnaction log. They back up enough of the log to ensure that the backup is consistent when restored.

Only a transaction log backup truncated the transaction log (in full and bulk-logged recovery modes)

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #497053
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse