How to Automate Synchronizing logins after failover RRS feed

  • Question

  • Since the logins/jobs do not get stay in sync between principal and mirror after a failover (when using sql logins), is there a workaround to schedule a job or something to automate dropping, re-creating and autofixing logins?

    I've read somewhere that an alert can be setup to run (after a failover) and a job can be executed, but cant seem to get this to work. Does anyone have any helpful hints on a solution to this

    Wednesday, December 13, 2006 5:28 PM


All replies