patternsqlMajor
Ola Hallengren with database mirroring
Viewed 0 times
withhallengrendatabasemirroringola
Problem
I am about to setup Ola Hallengrens database maintenance plan. We have our database mirrored and I was just wanting to know if I need to run the script on both my Sql Server instances or only the primary?
Solution
I recommend that you have the jobs enabled and scheduled on both servers and with the same configurations. Databases that are in a mirror role will automatically be skipped. There are checks for that in the script.
Context
StackExchange Database Administrators Q#60108, answer score: 26
Revisions (0)
No revisions yet.