Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: Wednesday, December 10, 2014 11:31 AM
Points: 133, Visits: 309
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 @ 3:46 AM
Points: 41,285, Visits: 37,877
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 2008, MVP
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