Red Gate forums :: View topic - Log Shipping Restore Stopping
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product documentation
SQL Backup Previous Versions
SQL Backup Previous Versions forum

Log Shipping Restore Stopping

 Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
blakedba



Joined: 31 Aug 2007
Posts: 6
Location: Boston MA
PostPosted: Mon Aug 23, 2010 5:48 pm    Post subject: Log Shipping Restore Stopping Reply with quote
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
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 262
Location: Cambridge, UK
PostPosted: Tue Aug 24, 2010 6:05 pm    Post subject: Reply with quote
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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group