hi, forum! First, if I don't have a third box, where is the best place to put the witness? It would seem to make sense to put it on the mirror.... Second, what are some of you guys doing to keep logins, jobs, and ssis packages in synch? I'd appreciate some ideas of how some of you are handling this - creative ideas welcome? Automation, if possible, is the key. For logins, I was thinking of setting up a job with linked server, just to generate the login output daily, so at least it will be on there on the mirror, in event of failover. THX!![]
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx You can restore msdb to move jobs, ssis packages etc... You can move the logins with scripts... http://blogs.interfacett.com/jeff-j...oving-logins-across-multiple-sql-servers.html Yes, you can create linked server or you can use OSQL/SQLcmd to copy the jobs and logins etc...daily..