Wednesday, March 7, 2012

Log Shipping and SQL Server Licence Requirement

Given that the secondary server can be configured in standby mode, what is
the minimum SQL Server licensing requirement for the secondary server?
thanks in advance
JamesThe "secondary server" is not in standby mode, only the database(s) you log ship is. So you need a
license for that server as well. See http://www.microsoft.com/sql/howtobuy/faq.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"James-Aus" <JamesAus@.discussions.microsoft.com> wrote in message
news:7A46C301-BBF6-4D55-AFC0-52939FE2877F@.microsoft.com...
> Given that the secondary server can be configured in standby mode, what is
> the minimum SQL Server licensing requirement for the secondary server?
> thanks in advance
> James|||This is a multi-part message in MIME format.
--=_NextPart_000_07A3_01C4F23E.E02BFD90
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
The EULA states that the passive node in a cluster configuration as well as
the SQL Server hosting only standby databases in a log-shipping
configuration may be hosted for disaster recovery purposes as long as SQL
Server is licensed for the host with the most CPUs if one were licensed
under the per-processor mode.
For CAL based installations, it is the number of CALs that need to be kept
up to date, but the SQL Server host that is acting in a passive capacity can
be installed under the active's license as long as only one is active at any
given moment.
Sincerely,
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in message news:%23ASMAQj8EHA.3236@.TK2MSFTNGP15.phx.gbl...
The "secondary server" is not in standby mode, only the database(s) you
log ship is. So you need a
license for that server as well. See
http://www.microsoft.com/sql/howtobuy/faq.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"James-Aus" <JamesAus@.discussions.microsoft.com> wrote in message
news:7A46C301-BBF6-4D55-AFC0-52939FE2877F@.microsoft.com...
> Given that the secondary server can be configured in standby mode, what
is
> the minimum SQL Server licensing requirement for the secondary server?
>
> thanks in advance
> James
--=_NextPart_000_07A3_01C4F23E.E02BFD90
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

The EULA states that the passive node =in a cluster configuration as well as the SQL Server hosting only standby =databases in a log-shipping configuration may be hosted for disaster recovery =purposes as long as SQL Server is licensed for the host with the most CPUs if one =were licensed under the per-processor mode.
For CAL based installations, it is =the number of CALs that need to be kept up to date, but the SQL Server host that is =acting in a passive capacity can be installed under the active's license as long =as only one is active at any given moment.
Sincerely,
Anthony Thomas
--
"Tibor Karaszi" wrote in message news:%23ASMAQj8EHA.=3236@.TK2MSFTNGP15.phx.gbl...The "secondary server" is not in standby mode, only the database(s) you =log ship is. So you need a license for that server as well. See http://www.microsoft.com/sql/howtobuy/faq.asp">http://www.microso=ft.com/sql/howtobuy/faq.asp-- Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asp">http://www.karaszi.=com/sqlserver/default.asphttp://www.solidqualitylearning.com/">http://www.solidqualitylear=ning.com/http://www.sqlug.se/">http://www.sqlug.se/"James-=Aus" wrote in message news:7A4=6C301-BBF6-4D55-AFC0-52939FE2877F@.microsoft.com...> Given that the secondary server can be configured in standby mode, =what is> the minimum SQL Server licensing requirement for the =secondary server?>> thanks in advance> James

--=_NextPart_000_07A3_01C4F23E.E02BFD90--|||That doesn't goes with the FAQ page I referred to:
Q. If I am doing log shipping in an active/passive failover configuration, how should I
license the backup server?
A. In this scenario, the active and passive servers must be licensed identically, so that the
passive server can process the same workload as the active server in the event of a failover.
Makes one wonder whether to go by the EULA or the FAQ page. I guess that the EULA is more legally
binding, so I would carefully read the text...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> wrote in message
news:%23udXVFn8EHA.1452@.TK2MSFTNGP11.phx.gbl...
> The EULA states that the passive node in a cluster configuration as well as
> the SQL Server hosting only standby databases in a log-shipping
> configuration may be hosted for disaster recovery purposes as long as SQL
> Server is licensed for the host with the most CPUs if one were licensed
> under the per-processor mode.
> For CAL based installations, it is the number of CALs that need to be kept
> up to date, but the SQL Server host that is acting in a passive capacity can
> be installed under the active's license as long as only one is active at any
> given moment.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:%23ASMAQj8EHA.3236@.TK2MSFTNGP15.phx.gbl...
> The "secondary server" is not in standby mode, only the database(s) you
> log ship is. So you need a
> license for that server as well. See
> http://www.microsoft.com/sql/howtobuy/faq.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "James-Aus" <JamesAus@.discussions.microsoft.com> wrote in message
> news:7A46C301-BBF6-4D55-AFC0-52939FE2877F@.microsoft.com...
> > Given that the secondary server can be configured in standby mode, what
> is
> > the minimum SQL Server licensing requirement for the secondary server?
> >
> > thanks in advance
> > James
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end|||I believe MS wants you license the warm standby as a production server.
Hence, it needs to have money spent on it.. :(
Eric D. Smith
St. Louis, MO
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uHl12Jn8EHA.3416@.TK2MSFTNGP09.phx.gbl...
> That doesn't goes with the FAQ page I referred to:
> Q. If I am doing log shipping in an active/passive failover
configuration, how should I
> license the backup server?
>
> A. In this scenario, the active and passive servers must be
licensed identically, so that the
> passive server can process the same workload as the active server in the
event of a failover.
>
> Makes one wonder whether to go by the EULA or the FAQ page. I guess that
the EULA is more legally
> binding, so I would carefully read the text...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> wrote in message
> news:%23udXVFn8EHA.1452@.TK2MSFTNGP11.phx.gbl...
> > The EULA states that the passive node in a cluster configuration as well
as
> > the SQL Server hosting only standby databases in a log-shipping
> > configuration may be hosted for disaster recovery purposes as long as
SQL
> > Server is licensed for the host with the most CPUs if one were licensed
> > under the per-processor mode.
> >
> > For CAL based installations, it is the number of CALs that need to be
kept
> > up to date, but the SQL Server host that is acting in a passive capacity
can
> > be installed under the active's license as long as only one is active at
any
> > given moment.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
wrote
> > in message news:%23ASMAQj8EHA.3236@.TK2MSFTNGP15.phx.gbl...
> > The "secondary server" is not in standby mode, only the database(s) you
> > log ship is. So you need a
> > license for that server as well. See
> > http://www.microsoft.com/sql/howtobuy/faq.asp
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> > http://www.sqlug.se/
> >
> >
> > "James-Aus" <JamesAus@.discussions.microsoft.com> wrote in message
> > news:7A46C301-BBF6-4D55-AFC0-52939FE2877F@.microsoft.com...
> > > Given that the secondary server can be configured in standby mode,
what
> > is
> > > the minimum SQL Server licensing requirement for the secondary
server?
> > >
> > > thanks in advance
> > > James
> >
> >
>
>

No comments:

Post a Comment