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

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?




  • Options
    Eddie DEddie D Posts: 1,793 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: support@red-gate.com
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.