Friday, March 30, 2012

multiple instances on one virtual server

In a failover cluster is there any way at all that more than one named SQL
Server instance can exist on a virtual server?
Thanks!No. Each virtual server can host exactly one instance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:D02ECF04-7BC1-41B5-B35D-88D938E28FCC@.microsoft.com...
> In a failover cluster is there any way at all that more than one named SQL
> Server instance can exist on a virtual server?
> Thanks!|||Hi,
Yes you can do that.
It is called a Multiple-Instance cluster. A Multile-Instance cluster
supports upto four nodes and supports 16 instances (1 default and 15 named o
r
16 named). This implementation requires extensive planning as each virtual
server requires its own disk resources that can not be shared by other
instances.
Hth
DeeJay Puar
MCDBA
"Robert Kinesta" wrote:

> In a failover cluster is there any way at all that more than one named SQL
> Server instance can exist on a virtual server?
> Thanks!

No comments:

Post a Comment