Index Rebuild on Mirrored Database

• kdv

  Old Hand

  Points: 368

  More actions

  January 29, 2009 at 3:04 pm

  #130494

  I have a database that has severely fragmented indexes. I need to do an ALTER INDEX REBUILD and do it offline because there is a text field on the table. Additionally, the database is mirrored.

  What affect does that have on the mirrored database? Are all the changes sent to the mirror? (Are the indexes currently on the mirror also fragmented?)

  I am running SQL Server 2005, SP2. The database is about 40GB and is primarily 1 table - I didn't do it! It is a vendor package!

  Thanks for any experiences!

• thasteve

  SSCrazy

  Points: 2707

  More actions

  January 30, 2009 at 6:29 am

  #935472

  The index rebuild works with the transaction log file so it will be mirrored over which can take quiet some time on a large Index rebuild.

• kdv

  Old Hand

  Points: 368

  More actions

  January 30, 2009 at 8:24 am

  #935585

  That's what I would have assumed. Thanks for the confirmation!