Is it possible to have an Active/Passive cluster in DATACENTER A that will serve as the PRINCIPAL and a single instance database server in DATACENTER B that will serve as the MIRROR?
Reason for this is - in 99,99 % of the case DATACENTER A is the primary site.
Datacenter B will only be used when DATACENTER 1 is completely down.
But to maintain high availibilty in DATACENTER A we setup a cluster instead of A single instance.
==> Principal (= A/P cluster) - Mirror (Single instance) - Would that work?
asked Feb 03 '12 at 02:55 PM in Default
Yes - the active/passive cluster is a single instance and you can mirror the databases in that single instance to another server.
The only thing to consider is that clustering works at an instance-level, whereas database mirroring is at the database level, so you COULD end up with one database being the principle in Datacentre B, with the rest of the databases being in prinicpal role at Datacentre A.
answered Feb 03 '12 at 03:03 PM
Kev Riley ♦♦