July 17, 2014 at 2:54 am
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
July 17, 2014 at 3:52 am
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" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply