• Ok, Guys the The Restore was successful and the Log shipping is back on sync. I can confirm it by looking at the restore log on the Log File Viewer.

    It says that the Restore Operation was successful.

    I have a question though. The database is now on "Restoring Mode" since we used "NO RECOVERY"

    Any idea how to bring it back to Standby Mode since we want to use this for Read purposes ?

    thanks.