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, September 30, 2015 6:31 AM
Points: 133, Visits: 313
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 @ 9:14 AM
Points: 42,998, Visits: 39,974
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
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