Home Forums SQL Server 2008 SQL Server 2008 - General Should we create an index maintenance such as Rebuild / Reorganize in the MIRRORING Server ? RE: Should we create an index maintenance such as Rebuild / Reorganize in the MIRRORING Server ?

  • Steve Jones - SSC Editor (10/6/2014)


    Agree with HappyCat. I'd set up the same jobs on both servers, but disable the jobs on the secondary. If you failover, you can enable them.

    Rather than just leaving the job disabled, I would include a step that checks whether the database is the current primary and conditionally do the index maintenance. Not only do you end up with mirroring failing over automatically, your index maintenance is also automatic. Otherwise you end up with yet another thing to remember to do.