We have a mirrored DB server and we were thinking of ways to verify the principal and mirror are in sync and create reports for our peace of mind and audit purposes.
Do you think SDC will work to compare the data between the principal and the mirror even though the mirror DB is apparently in recovery mode all the time?
The two boxes are SQL Server 2005 Standard and sit on the same LAN.
One more thing, would there be any performance overhead that should be considered on either box if we were to use SDC?
Thanks a ton,