Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2012-01-02 : 15:40:49
|
| Do you need enterprise edition on both the main server and the mirrored server in order to use async mirroring or just the main server?Thanks,Craig |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-02 : 16:49:13
|
| The two should be the same version. Mirroring instances should be exactly the same version, edition and patch.If you could mirror between Enterprise and Standard (and I don't know whether you can or not), consider that should that mirroring fail over, the mirroring would break. Hence you have there a HA solution that you can't fail over. Not really a good idea.--Gail ShawSQL Server MVP |
 |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2012-01-02 : 16:57:28
|
quote:
Originally posted by GilaMonster
The two should be the same version. Mirroring instances should be exactly the same version, edition and patch.If you could mirror between Enterprise and Standard (and I don't know whether you can or not), consider that should that mirroring fail over, the mirroring would break. Hence you have there a HA solution that you can't fail over. Not really a good idea.--Gail ShawSQL Server MVP
The problem I have is that our hosting provider (Rackspace) contends that we need to license the mirrored server (which I didn't think was necessary) and the cost of Enterprise is huge compared with Standard. I can maybe justify upgrading the main server to Enterprise but paying Enterprise license for the mirrored server inflates our costs too much :( |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-03 : 05:11:38
|
| You don't need to license the failover server providing it's not being used for other databases or for reporting (snapshot off the mirror). If it is only the mirrors of databases, then it's covered under the failover provisions in the licensing rules, and doesn't need to be licensed unless you failover and stay that way for 30 days.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
async mirroring with enterprise edition