Simple Recovery and Log Shipping

blakedba

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

Eddie D

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: support@red-gate.com