Log Shipping Restore Stopping

Forum for users of Red Gate SQL Backup tool

Moderator: Chris Auckland

Log Shipping Restore Stopping

Postby blakedba » Mon Aug 23, 2010 5:48 pm

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
 
Posts: 6
Joined: Fri Aug 31, 2007 5:06 pm
Location: Boston MA

Postby chriskelly » Tue Aug 24, 2010 6:05 pm

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
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest