|
I am doing some preliminary research on providing a mirroring solution, as part of a new project. Management don't want to make a great deal of budget available for this, so I'm being asked to shoehorn it into existing kit (of course, the project is allowed new kit!). Essentially, the proposed server for witnessing is a lives in a different VLAN from the new home of the project servers and runs a different version of SQL Server. A firewall enforces separation between the VLANs such that the witness is on the outside, while the project servers are on the inside. I need to know whether I can rely solely on the implicit allow-inside-to-outside rule, or whether I need to allow explicit outside-to-inside traffic (for the witness endpoint port); and whether or not I need to add special rules to prevent the firewall dropping the connection after a certain amount of time. So, I have a couple of questions that I can't seem to find any definitive answer on. I'm hoping that they are actually faily straightforward to someone who has actually done some or all of this:
(comments are locked)
|
|
Answer to question 1: Database mirroring partners are supported only by SQL Server 2005 Standard and later versions and by SQL Server 2005 Enterprise Edition and later versions. Witnesses, in contrast, are also supported by SQL Server 2005 Workgroup and later versions and by SQL Server 2005 Express Edition and later versions. Except during an upgrade from an earlier version of SQL Server, the server instances in a mirroring session must all be running the same version of SQL Server. ,answer to 1: Database mirroring partners are supported only by SQL Server 2005 Standard and later versions and by SQL Server 2005 Enterprise Edition and later versions. Witnesses, in contrast, are also supported by SQL Server 2005 Workgroup and later versions and by SQL Server 2005 Express Edition and later versions. Except during an upgrade from an earlier version of SQL Server, the server instances in a mirroring session must all be running the same version of SQL Server.
(comments are locked)
|
|
To answer #1: Yes -
from MSDN Sorry I'm not technically-able enough to answer the second part! :(
(comments are locked)
|

