On logshipping

  • 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

  • Rather than creatining an additional transaction log backup, you should modify your log shipping configuration by increasing the frequency of the log backup job.

  • 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.

  • 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

  • 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