September 27, 2010 at 9:32 am
Hi,
We're contemplating using log shipping for a warm standby and reporting solution. I'm happy with the limitations around single-user access during restores, and the prospect of large log files when we reorganise tables on the primary server.
My question is - if you do perform a reorg on a table in the master, do the logs that get produced actually reorganise the index on the log-shipped secondary? One would hope that the large logs produced would be of some benefit at the other end! I would not want the reporting performance to degrade over time. Can't find anything that addresses this.
September 27, 2010 at 3:33 pm
yes it does.
All the page moving that reindexing does is recorded in the log so is therefore replayed on the secondary database.
Just the same as if you restored a database and followed that by restoring tran logs that rolled through an index rebuild, you would expect to end up with a database that reflects ALL activity up to that point.
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply