Indianrock (6/3/2009)
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
After the restore database with no recovery mode, you cannot bring back to that state again.
As restore database with no recovery mode is a transaction, newly created Log Sequence number(LSN).
after you take backup from new shinny recovery database and try to restore it again with no recovery mode, then Logshipping try to restore same start number LSN but different end LSN.
You cannot recovery and backup logshipping destination database hoping that it not break logshipping.