Home Forums SQL Server 2005 Backups Suspend log shipping restore for full backup on standby RE: Suspend log shipping restore for full backup on standby

  • In test, this is working up to the point of putting the database back in standby or no recovery mode.

    Msg 3153, Level 16, State 1, Line 1

    The database is already fully recovered.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    Tried restoring oldest t log backup not yet restored and got this

    restore LOG pst from disk='F:\MSSQL\LOGSHIPBACKUPS\pst_20090603121501.trn' WITH NORECOVERY

    Error:The log or differential backup cannot be restored because no files are ready to rollforward