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?

Thanks

John

Comments

  • 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:
    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/17ca2e0a-016d-4fb8-83b7-354578d6cfb9.htm

    Switching from the Full or Bulk-Logged Recovery
    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/b3467e32-b6aa-44b1-afb9-e873f65e8618.htm

    Switching from the Simple Recovery Model:
    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2b59bdfe-7d8c-4322-84b8-f5127ddca5fa.htm

    Many Thanks
    Eddie

    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.