November 28, 2014 at 4:11 am
Hi there - I need to design a DR solution. We have multiple 1TB databases which have a full daily and transactional backup every 15 mins.
If I set up log shipping will this effect the transaction log backups i.e. does log shipping perform a checkpoint which will impact data loss?
Our full backups run for over an hour, whilst these are running I would still like the log shipping to happen, will this still be the case?
Thanks!
--------------------------------------------
Laughing in the face of contention...
November 28, 2014 at 4:17 am
If you implement log shipping, those MUST be the only log backups running against that database
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2014 at 4:18 am
Ok, thanks. Are there any techniques to get around this?
--------------------------------------------
Laughing in the face of contention...
November 28, 2014 at 4:26 am
It's not something to get around. It's how log backups work. When you implement log shipping, it must replace any current log backup job. Otherwise neither the log shipping nor the normal log backups will work.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 28, 2014 at 4:36 am
Ok, thanks.
--------------------------------------------
Laughing in the face of contention...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply