SQL Server Performance

Some mirroring questions....

Discussion in 'SQL Server 2005 Database Mirroring' started by sql_jr, Jun 9, 2008.

  1. sql_jr New Member

    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.
  2. MohammedU New Member

  3. dineshasanka Moderator

    If you dont' have thrid box, there is no way that you can configure the witness server.

Share This Page