• unematt - Monday, November 20, 2017 4:46 PM

    That worked! Now I'm getting the 'Database is not in recovery or standby mode' error. I selected not to need this when I setup the log shipping, not sure how to get the DB to restore without it in either of those modes. 

    Thanks Sue!

    Matt

    When you set this up, I would guess you selected the option for the database already being initialized. It wasn't and the database is on the secondary fully recovered. That won't work. The logs can't be restored when the database is fully recovered. Sorry but now you get to try again. Try initializing from a new full backup - the option is something like Generate a full backup and restore it on the secondary. It's the first option on the initialization page. 

    Sue