How can we help you today? How can we help you today?

Log shipping - Full or Bulk-Logged recovery model

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
mdolan
0

Comments

2 comments

Sort by
  • 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
    Jason Cook
    0
  • 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
    mdolan
    0

Add comment

Please sign in to leave a comment.