Log shipping - Full or Bulk-Logged recovery model

mdolan

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

Jason Cook

The following link may help to answer your questions:
http://msdn2.microsoft.com/en-us/library/ms190203.aspx

The log shipping should continue unaffected, since you are still generating logs, and have not broken the log chain. The one major thing to note from the article is to perform a log backup directly before, and directly after, the change to/from bulk-logged mode to minimise any potential loss if a server failure was to occur during that period.

Hope that helps,
Jason

mdolan

Hello Jason,
The article from the book online was great. I forgot to mention that I'm working with SQL 2000, so I went into the SQL 2000 BOL and found a similar article on switching recovery models.

http://msdn2.microsoft.com/en-us/librar ... 649(SQL.80).aspx

Thanks,
Matt