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

    Another question, after log shipping has been setup, can you change between No Recovery and Standby mode or do you need to start all over?