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
Author
Message
Posted Thursday, May 8, 2008 6:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, December 1, 2012 6:15 AM
Points: 132, Visits: 302
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

Thanks.

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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:22 AM
Points: 39,867, Visits: 36,213
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