none
SQL server 2005 Mirroring RRS feed

  • Question

  • I am trying to set up a SQL mirroring senario - I have some questions

    Do I need to purchase an extra SQL Server license for the SQL server instance on the Mirror? what about the Witness does that also need a separate license/

    Can the witness be a virtual server on the Mirror box itself? Do I still require a license if the witness is on a virtual server?

    Thanks

    jawahar

    Wednesday, August 16, 2006 7:02 PM

Answers

  • #1.  If you are using your second server only as a standby system for a failover scenario, you don't need a separate SQL Server license for the standby machine.  I got this straight from MS.

    #2 Correct.  Any flavor of SQL Server can act as a witness.
    Thursday, September 14, 2006 1:36 PM

All replies

  • I think
    Mirror - you do need another license
    Witness - you could run it off any other SQL server, or use the FREE SQL Server 2005 Express
                    regardless of VM or not

    If you need OS for VM, Windows 2003 Enterprise allows up to 4 VM licenses (ie. 1 host + 4 VM)
    Wednesday, August 16, 2006 8:01 PM
  • #1.  If you are using your second server only as a standby system for a failover scenario, you don't need a separate SQL Server license for the standby machine.  I got this straight from MS.

    #2 Correct.  Any flavor of SQL Server can act as a witness.
    Thursday, September 14, 2006 1:36 PM