How can we help you today? How can we help you today?

Log Shipping Restore Stopping

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
blakedba
0

Comments

1 comment

Sort by
  • 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.
    chriskelly
    0

Add comment

Please sign in to leave a comment.