• 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)?