March 6, 2009 at 8:10 am
My servers are running on sqlserver2005 and configured one of high avil... solution like logshipping, now my log file is growing abnormally i have to take log backup now, if it is done lsn mismatch will occur. In this sutation what i have to do.
Please can any one help me.
With regards:
amar
March 6, 2009 at 8:20 am
Rather than creatining an additional transaction log backup, you should modify your log shipping configuration by increasing the frequency of the log backup job.
March 6, 2009 at 10:53 am
Disable all the logshipping jobs:
Manually Kick off the Logshipping-backup log job onyour primary server;
when it is finished, manually start the logshipping copy job;
then start the restore job on the secondary server..
Then Enable all the LS jobs.
March 6, 2009 at 3:54 pm
sunny Brook (3/6/2009)
Disable all the logshipping jobs:Manually Kick off the Logshipping-backup log job onyour primary server;
when it is finished, manually start the logshipping copy job;
then start the restore job on the secondary server..
Then Enable all the LS jobs.
NICE!
* Noel
March 10, 2009 at 12:09 am
Thank you for providing this information.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply