Re: Licensing for DB mirroring

Yes Ben is 100% correct. As long as you don't use it for anything other than a pure mirror it does not require a license similar to the way clustering works.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Ben Nevarez" <BenNevarez@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:49B3073A-96F1-4594-8EE7-8E8F5B7FD1C8@xxxxxxxxxxxxxxxx

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: Processor Based License Model
    ... >> Maybe for databases what we really need is a license that permits X ... >> of transactions per seccond to be processed by the database. ... > SQL Server license. ... > Man would I like to have something like this for Rdb. ...
    (comp.os.vms)
  • Re: Quick Question on SQL Server 2005 Express
    ... I wondered if we need any type of license to use Management Tools on a non-licensed machine so I asked to the Server and Tools Product Manager of Microsoft Turkey, whose name is Selma Karaca, I had met her on several Microsoft seminars which are held here in Istanbul... ... Server tools or technologies installed must have a valid SQL Server license. ... I have installed SQL Server 2005 Express, and now I want to connect to the remote database and use the Management Studio to manipulate the database. ...
    (microsoft.public.sqlserver.setup)
  • Re: Quick Question on SQL Server 2005 Express
    ... I wondered if we need any type of license to use Management Tools on a non-licensed machine so I asked to the Server and Tools Product Manager of Microsoft Turkey, whose name is Selma Karaca, I had met her on several Microsoft seminars which are held here in Istanbul... ... Server tools or technologies installed must have a valid SQL Server license. ... Notification Services Client Components ... I have installed SQL Server 2005 Express, and now I want to connect to the remote database and use the Management Studio to manipulate the database. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cant start mirroring
    ... Not setting mirror database' s recovery state as norecovery is one of the reasons of this problem. ... Are your Logins identical on your Principal and Mirror SQL Server Instances? ...
    (microsoft.public.sqlserver.setup)
  • Re: How to add FILEGROUP?
    ... > I'm using SQL Server 2000 Standard Edition. ... SE support 32TB per database file, and sum of about 1,000,000 TB totally for the db. ... > If license issue, then how much SQL Server 2000 Standard Edition could cater ... > If filegroup, I had been created some which each one max size is 2GB? ...
    (microsoft.public.sqlserver.server)