July 12, 2011 at 7:11 am
hi,
i want to implement log ship in our comapny - i know log ship working on log file,
the problem - as apart of my backup strategy i backup my log every 10 ninute...
and backup to log clean the log so there is away that sql now to handle with this situation
or i should to stop backup the log and base on log back from log shiping?
sharon
July 12, 2011 at 7:44 am
I don't think you need to have two different log backup jobs now. Log shipping job on Primary server will do the log backup and copy it over to the secondary server, So, you'll have a copy of your trn file on primary server if needed. You can retain it for whatever time you need.
July 12, 2011 at 8:10 am
If you're doing log shipping then the log backups done by the log shipping MUST be the only ones you do. If you take other log backups that aren't shipped, log shipping will fail very quickly.
Log backups form a chain. If you are restoring you need all of them.
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
July 12, 2011 at 8:10 am
apat (7/12/2011)
Log shipping job on Primary server will do the log backup and copy it over to the secondary server,
The backup job on the primary server does not copy the log backup to the secondary, the copy job on the secondary server does this!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2011 at 8:39 am
thank you
help me very much
July 12, 2011 at 10:57 am
Perry Whittle (7/12/2011)
apat (7/12/2011)
Log shipping job on Primary server will do the log backup and copy it over to the secondary server,The backup job on the primary server does not copy the log backup to the secondary, the copy job on the secondary server does this!
Yes you are right.. I typed so fast and forgot to include Secondary server to copy the trn files over... Thanks for the correction...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply