October 6, 2014 at 5:18 pm
Should we create an index maintenance such as Rebuild / Reorganize in the MIRRORING Server ?
I already have the index maintenance in PRINCIPAL server .
Please kindly advise .
Many Thanks !!
Cheers
October 6, 2014 at 9:06 pm
The current secondary does not need a maintenance plan - it is not updateable and attempting to do index maintenance would require updates to be done.
The results of any index maintenance on the primary are sent to the secondary anyway so there is no need to worry about it.
However, when the roles of the primary and secondary database change, you may need to change the maintenance done on the what was the secondary (and is now the primary).
October 6, 2014 at 9:08 pm
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 6, 2014 at 10:16 pm
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.
thanks a lot for both of u !!
your suggestion is very helpful
October 30, 2014 at 5:09 pm
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.
October 31, 2014 at 9:22 am
happycat59 (10/30/2014)
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.
+1
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply