I am trying to implement DR in my ENV.
Control-M version is 7
DB is MSSQL 2008
Control-M/EM and it DB is installed on ACTIVE/PASSIVE in Production SITE , and both are on different cluster.
IN DR Control-M/EM installed on VM and DB is installed on ACTIVE/PASSIVE .
I am thinking if i enable SQL logshipping/Mirroring between Production and DR, what all actions/Queries to execute in e DR DB to reflect in DR config information from PROD config when DR happens.
I appreciate if anyone share the idea and experience