What are the challenges you face when working across database platforms? Take the survey
Options

Log Shipping Restore Stopping

blakedbablakedba Posts: 11
edited August 24, 2010 1:05PM in SQL Backup Previous Versions
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

Comments

  • Options
    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.
Sign In or Register to comment.