Log Shipping Restore Stopping

blakedba

Hello,

I have a Sql job that runs every Tues and Fri at 1:05 AM and does the following.

Set recovery to Bulk

DBCC DBREINDEX

DBCC UPDATEUSAGE

DBCC CHECKCATALOG

DBCC CHECHCONSTRAINTS

DBCC CHECKDB

sp_MSforeachtable UPDATE STATISTICS ? WITH FULLSCAN

Set Recovery FULL

The logshipping restore database is in another facility connected to a 6mb network.

For some reason the restore will not run after 1:00 am on these days.

Is this because on the Bulk Recovery change?

Thanks in advance

John Blake

chriskelly

Yes. It is most likely because of your recovery model change. Whenever you change this you need to run a new FULL backup. From the look of your task a FULL backup after changing back to the FULL recovery model should be sufficient to bring everything back into line.