August 18, 2010 at 4:13 pm
Hi,
I have question here. I have database that is participating in Log shipping and another database in Database Mirroring and I wanted to know when I actually insert the data in primary database of log shipping, the data will be replicated. My question is due to large scale updates the data will be fragmented in the primary database and this fragments have any effect in secondary or mirrored database. If there would be a fragmentation on secondary database? and if I defragment the data using indexes on primary server will there would be a effect of defragmentation of secondary server also?
Thanks,
Ravi
August 19, 2010 at 3:31 pm
RaviShankar1234 (8/18/2010)
and if I defragment the data using indexes on primary server will there would be a effect of defragmentation of secondary server also?
Yes, the secondary database's index in log shipping or mirror database's index in database mirroring will be defragged or rebuilt just like on the primary or principal.
Mirroring and log shipping work at the transaction level. Which means when you issue an
ALTER INDEX <INDEXNAME> ON <TABLENAME> REBUILD
that transaction is shipped or mirrored to the secondary or mirror server and applied there.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply