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 the log file with a log shipped enabled database Expand / Collapse
Author
Message
Posted Thursday, July 17, 2014 2:54 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, October 31, 2014 9:30 AM
Points: 193, Visits: 505
When log shipping is set up, are the log shipping backups then same as a standard backup and log backups?

I.e. will the LDF files be emptied out every time the log shipping runs so my log file doesn't keep growing?

Many thanks
Post #1593443
Posted Thursday, July 17, 2014 3:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:53 AM
Points: 6,742, Visits: 14,381
Edward-445599 (7/17/2014)
When log shipping is set up, are the log shipping backups then same as a standard backup and log backups?

Yes, a LogShipped database will have a transaction log backup job on the Primary server. This job takes a standard transaction log backup, full backups will still be managed by your instance backup regime.


Edward-445599 (7/17/2014)
I.e. will the LDF files be emptied out every time the log shipping runs so my log file doesn't keep growing?

Many thanks

Yes, a transaction log backup will truncate any committed transactions, note that in certain scenarios though the log can still grow.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1593460
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse