Competition: What’s your favorite Redgate tool? Enter now.

Simple Recovery and Log Shipping

blakedbablakedba Posts: 11
edited May 6, 2008 11:39AM in SQL Backup Previous Versions
I have logshiping running from 6am - 11pm and a scheduled backup of production database running @ 10pm nightly.

Due to the activity of our database we need to run REINDEX a couple of times a week (Tues and Sat at 0100)

Since the first step of the job is to set the DB to Simple Recovery - will this always mess up the log shipping restore that happens @ 0600?




  • Eddie DEddie D Posts: 1,687 Rose Gold 5
    Thank you for your post into forum.

    Can you please modify your re-indexing job to use the BULK_LOGGED recovery model.

    You can switch between FULL and BULK_LOGGED recovery models without the need to perform a full backup and this should not mess up your log shipping scenario.

    Further advice can be found in the following SQL Server 2005 Books On-Line Artilces:

    Choosing the Recovery Model for a Database:

    Switching from the Full or Bulk-Logged Recovery

    Switching from the Simple Recovery Model:

    Many Thanks

    Eddie Davis
    Product Support Engineer
    Red Gate Software Ltd
    E-Mail: [email protected]
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.