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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy