• david 81886 (7/8/2014)


    Thanks guys... so I did the manual backup/restore w/ No Recovery and then setup log shipping. All seemed to proceed without error. However, I'm not sure how to tell if it's truly working properly. When I run a log shipping status report, I'm seeing a Red Alert, but when I look at the LSBackup, LSCopy and LSRestore job history, everything is green and happy?

    Yes the jobs will always usually show success. Check the individual step output for each step, errors will be listed here.

    david 81886 (7/8/2014)


    Another question, after log shipping has been setup, can you change between No Recovery and Standby mode

    Yes you can

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉