arkiboys (10/25/2012)
GilaMonster (10/25/2012)
If the mirroring is working, the data in the mirror DB will be correct. You could take a snapshot off the mirror and query that if you want.SQL Agent jobs are not included in mirroring, mirroring is just the DB you configure, jobs are in MSDB. If you want them, you have to transfer them.
The applications (User screens) are pointing to the machine m (Prod server).
how do I know that if the machine m goes down, then automatically the applications are redirected to the mdr (DR database machine)?
Depending on your applications connectivity (only through ADO.NET or SQL Native client IIRC) there is a "Failover Partner =" option for the connection string which will automatically redirect to a mirror partner.
What mode is your mirroring session using, do you have a witness server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉