Best approach to find missing logins and missing jobs between principal and mirror server

by BeginnerDBA   Last Updated August 17, 2017 23:06 PM

I am doing a manual comparison of the logins and jobs between Principal and Secondary server, when doing database failover from P to S. I copy both the logins and jobs from one server to excel and compare them to those on the other.

Could someone please suggest a way to automate at least part of this check?

Note - I am doing this before doing a database failover as a pre-check, just to ensure that the secondary isn't missing anything as compared to the principal, so as to avoid a break after mirroring database failover.



Related Questions





SQL Server Always ON

Updated May 15, 2016 08:02 AM