Re: Instances in Virtual SQL Servers

#1

On a cluster you get one default instance and 15 named instances OR 16 named
instances. Of course you don't have to create all the instances, these are
just maximum numbers. The number of hosts in the cluster doesn't matter
towards the instance count.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"walkman" <walkman (AT) discussions (DOT) microsoft.com> wrote

Quote:

Can someone explain setting up instances in virtual SQL Servers? I know
that you can have multiple virtual SQL Servers on a cluster, but does each

default instance, or is it one default instance on the cluster no matter how
many virtual servers you have?

Quote:

Thank you.

#2

Each Virtual Server gets a single instance. It can be either a named
instance or a default instance, however only one such virtual server per
cluster can hold a default instance. This is because of how SQL stores the
binaries for each instance locally on each host node.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"walkman" <walkman (AT) discussions (DOT) microsoft.com> wrote

Quote:

Thank you. I was confused in that I thought each virtual machine would
have its own default instance.

"Geoff N. Hiten" wrote:

On a cluster you get one default instance and 15 named instances OR 16
named
instances. Of course you don't have to create all the instances, these
are
just maximum numbers. The number of hosts in the cluster doesn't matter
towards the instance count.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"walkman" <walkman (AT) discussions (DOT) microsoft.com> wrote in message
news:232E50F3-15CA-40DA-9ABA-4026EA8400B6 (AT) microsoft (DOT) com...
Can someone explain setting up instances in virtual SQL Servers? I
know
that you can have multiple virtual SQL Servers on a cluster, but does
each
default instance, or is it one default instance on the cluster no matter
how
many virtual servers you have?

Thank you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Instances in Virtual SQL Servers

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: Instances in Virtual SQL Servers - 07-06-2004 , 10:43 AM

Re: Instances in Virtual SQL Servers - 07-06-2004 , 10:59 AM