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

Log shipping - Full or Bulk-Logged recovery model

mdolanmdolan Posts: 11
edited August 15, 2007 10:06AM in SQL Backup Previous Versions
I have log shipping across a WAN working now using the Full recovery model. I want to run DBCC REINDEX on my tables, but that will generate a huge amount of logging. I can switch to the Bulk-Logging recovery model to get around that.

Can I switch the recovery model and still use the transaction logs via log shipping? Will it work?

Do I need to switch back to Full recovery model first?

Will switching the recovery model break the logging chain and require a restore from a full backup to get log shipping running again?

Thanks,
Matt
Matt Dolan
T-Systems International

Comments

Sign In or Register to comment.