help log shipping

[Nowell]

Hi,

I just accidently deleted a database that was being log shipped to, and now it wont restore the logs.

I restored the database, and when I try to restore the logs by running the old job it tells me this:

Executed as user: sa. The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step. [SQLSTATE 42000] (Error 4306) RESTORE LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013) Mail sent. [SQLSTATE 01000] (Error 17967). The step failed.


Err help, gonna get my ass kicked for this

 

[nigelrivett]

Use the norecovery option on the restore of the database (and all the logs).
(See bol)

You will have to restore all the logs from that backup.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Nowell]

Hi,

Thanks for you reply, I have already fixed this, but you were correct anyway.