vCenter DB mirroring

For various reasons we don't have a SQL failover cluster setup. Our current SQL DB failover is DB mirroring. Is there a way to setup vCenter so that it recognize mirrored DB as backup server? Did some search online and all results came back relating to failover cluster.

Find more posts tagged with

Comments

jibbajabba

dave330i wrote: »

For various reasons we don't have a SQL failover cluster setup. Our current SQL DB failover is DB mirroring. Is there a way to setup vCenter so that it recognize mirrored DB as backup server? Did some search online and all results came back relating to failover cluster.

Don't think it is possible per-se, first google hit shows an option though

Technology Nuggets: VMware Vcenter redundancy using database mirroring technology

You'll obviously have to setup a witness server to have the automated failover sorted.

dave330i

jibbajabba wrote: »

Don't think it is possible per-se, first google hit shows an option though

Technology Nuggets: VMware Vcenter redundancy using database mirroring technology

You'll obviously have to setup a witness server to have the automated failover sorted.

Thanks. Looked at the link. Didn't even think about doing something like that. We should have SQL failover clustering setup within a month or so. Probably easiest to wait until that's setup.

jibbajabba

To be honest though, you may as well use your infrastructure and virtualise SQL and vCenter and depending on licenses make use of HA/DRS or even FT

meadIT

jibbajabba wrote: »

To be honest though, you may as well use your infrastructure and virtualise SQL and vCenter and depending on licenses make use of HA/DRS or even FT

Unfortunately, FT is not supported for vCenter due to only supporting 1 vCPU.

dave330i

jibbajabba wrote: »

To be honest though, you may as well use your infrastructure and virtualise SQL and vCenter and depending on licenses make use of HA/DRS or even FT

Thanks for the advice. I had SQL as VM in a DRS cluster at previous employment. Unfortunately hardware at new employment is forcing us to keep SQL physical.