HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMajor

Ola Hallengren with database mirroring

Submitted by: @import:stackexchange-dba··
0
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.