Can anyone help me out with hopefully a simple question?
if I have a VM with a SQL DB which is protected via SnapCenter SCSQL, then the DB volumes Snapmirror udpate is managed via SnapCenter and we have an offsite copy that is application consistent.
If I want to fail over the same VM via SRM, it wants to snap and mirror all the volumes to the secondary site, I assume the DB volume snaps will not be application consistent or registered with Snapcenter therefore on failover I may not have an active DB?
Therefore how do I fail over this VM and make sure the DB is consistent on recovery?
Can I use SRM and Snapcenter together, or do I need to abandon SRM and have a VM built and ready at the DR site and then mount the Snapcenter protected volumes/DBs in the event of a failover.
Welcome any suggestions and solutions adopted to shed light on this