Re: Licensing for DB mirroring


Hi,

Actually you do not need a license for the database server running the
mirror databases.

But if you use the database server for something else like creating a
database snapshot on the mirror database you will need a license.

See more details here:

SQL Server Pricing and Licensing
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

Hope this helps,

Ben Nevarez
Senior Database Administrator
AIG SunAmerica



"Ekrem Önsoy" wrote:

I've not seen\heard anything like you claim besides it does not make sense.
Because it's not something like a SQL Server Failover Cluster' s
Active\Passive thing.

In database mirroring, second node' s (which holds the mirror database) SQL
Server services must be running actively. So this means it's being used
actively. So it needs license.

In a two node cluster, if one SQL Server node is running and the second node
is waiting in a standby mode for a failover then you do not need another
license for the passive node. Because it does not work concurrently.
However, in Database Mirroring, the second SQL Server service should be
running on the second server itself to keep Database Mirroring up.

However, I searched Google and could not find a document about this which
proves my opinion nor yours. You can ask to a local authorized software
license vendor.

--
Ekrem nsoy



"Fabio Gava" <esa_ud@xxxxxxxxx> wrote in message
news:%23PLemFANIHA.3940@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
i've read that if you use the second instance of SQL Server 2005 as DB
mirror only you don't need a second licence to run it. Is this correct?

Eventually, to implement a 2-node DB mirror, what I need is:

2 Windows Server 2003 Std
1 SQL Server 2005 Std

Is this correct?

Many thanks

-f


.

Relevant Pages

  • Re: replication
    ... mode, when a session begins, the mirror server synchronizes the mirror ... database with the principal database as quickly as possible. ... substantial if the principal server is under a heavy work load or the ...
    (comp.databases.ms-sqlserver)
  • Re: replication
    ... Roy Harvey (SQL Server MVP) wrote: ... mode, when a session begins, the mirror server synchronizes the mirror ... database with the principal database as quickly as possible. ... substantial if the principal server is under a heavy work load or the ...
    (comp.databases.ms-sqlserver)
  • Re: Licensing for DB mirroring
    ... you have up to 30-days to keep it live without license and failback to the ... than a pure mirror it does not require a license similar to the way ... Actually you do not need a license for the database server running the ... SQL Server Pricing and Licensing ...
    (microsoft.public.sqlserver.setup)
  • Re: Client license question
    ... > I think that anyone interacting with the database from ... >licenses or by a processor license on the web server. ... SQL Server 2005 Express Edition may ...
    (microsoft.public.sqlserver.clients)
  • Re: Pervasive SQL 9.0 performance issue on a Terminal Services server with Windows 2003
    ... really have a 50-User PSQLv9 database engine license. ... server as the user environments. ...
    (comp.databases.btrieve)