Post reply

Index Rebuild on Mirrored Database

  • 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!

  • 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.

  • January 30, 2009 at 8:24 am

    #935585

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply