Post reply

Log Shipping Restore job failing

  • November 11, 2009 at 11:26 am

    #227882

    We had to take down the SQL Agent on our primary server due to an emergency and because of that our secondary server is now failing on the lsrestore for the two SQL Agent jobs that are responsible for the lsrestore portion of our log shipping. Can anyone offer any suggestion regardin how I can bring the transactions up to synch to get the lsrestore to once again add the new transactions into these databases?

    Your help would be greatly appreciated.

    Thank you,

    David

  • November 11, 2009 at 11:38 am

    #1077960

    What's the error?

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 12, 2009 at 1:04 am

    #1078196

    Hi Ii am having same issue.

    Restoring stuck . restore db with no recovery stucking not completed.

    Regards

    Suresh

  • November 19, 2009 at 11:47 am

    #1081757

    Post the errors...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply