• Andrew G (7/3/2013)


    You don't need to fail-over at all, just break mirroring, then RESTORE WITH RECOVERY on the mirror to make it useable. Then recreate the mirror after the testing.

    Make sure you disable any automated log backups on prod too, or you'll need to restore those when you recreate the mirror.

    Thanks Andrew, but they do want to go through that failover process as if it's a real disaster......So, I can't really follow your steps.

    Any other suggestions?

    SueTons.

    Regards,
    SQLisAwe5oMe.