Re: Licensing for DB mirroring

Also, look out for the 30-day clause in the licensing which states that if
you failover to the mirror/standby instance (also applies for log shipping),
you have up to 30-days to keep it live without license and failback to the
original primary server within that span of time. Anything in excess of
30-days will require a license on the mirror/standby instance


"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:9F0E02EB-FBFB-43FA-88E8-AEFF5E056BEC@xxxxxxxxxxxxxxxx
That's great! I didn't know that.

--
Ekrem Önsoy



"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:eYxdMOHNIHA.820@xxxxxxxxxxxxxxxxxxxxxxx
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)
Loading