dbTalk Databases Forums  

New Named SQL Server 2008 Instance in existing Cluster - HowTo?

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


Discuss New Named SQL Server 2008 Instance in existing Cluster - HowTo? in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: New Named SQL Server 2008 Instance in existing Cluster - HowTo? - 11-06-2008 , 10:06 AM






You were good until the last sentence.

You cannot share resources, including disk resources, between instances.
You get one instance per "Service or Application".

For a second instance, you will need new disks, a new network name, and a
new IP address.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"John Myren" <john.myren(@).hemnekraftlag.no> wrote

Quote:
How do we add a new Named Instance under Services and Applications for the
existing SQL 2008 Cluster? We have the default MSSQLServer installed and
working OK.

We want to share the same data disk's for both Instances. Is this
possible?



Reply With Quote
  #12  
Old   
James White
 
Posts: n/a

Default how to add an instance - 01-05-2010 , 05:06 PM






I have a SQL cluster running and would like to add an instance. What is the procedure? I have different disks available for the new instance.



Geoff N. Hiten wrote:

You were good until the last sentence.
06-Nov-08

You were good until the last sentence.

You cannot share resources, including disk resources, between instances.
You get one instance per "Service or Application".

For a second instance, you will need new disks, a new network name, and a
new IP address.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"John Myren" <john.myren(@).hemnekraftlag.no> wrote


Previous Posts In This Thread:

On Thursday, November 06, 2008 7:43 AM
john.myren wrote:

New Named SQL Server 2008 Instance in existing Cluster - HowTo?
How do we add a new Named Instance under Services and Applications for the
existing SQL 2008 Cluster? We have the default MSSQLServer installed and
working OK.

We want to share the same data disk's for both Instances. Is this possible?

On Thursday, November 06, 2008 11:06 AM
Geoff N. Hiten wrote:

You were good until the last sentence.
You were good until the last sentence.

You cannot share resources, including disk resources, between instances.
You get one instance per "Service or Application".

For a second instance, you will need new disks, a new network name, and a
new IP address.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"John Myren" <john.myren(@).hemnekraftlag.no> wrote



Submitted via EggHeadCafe - Software Developer Portal of Choice
EggheadCafe Stock Quote WebService
http://www.eggheadcafe.com/tutorials...k-quote-w.aspx

Reply With Quote
  #13  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: how to add an instance - 01-06-2010 , 09:54 AM



Simply run the SQL installer again and create a new clustered SQL Instance.
Note that the new instance will also need a new, unique IP address and a
network name in addition to the disk resource. It works exactly the same as
the first time, except shared components are already installed and will be
skipped this time around.

I am assuming the disks are already set up as clustered disks. If not, you
need to do that first so they are in the Available Storage group.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"James White" wrote in message news:20101518628jlwblogger (AT) gmail (DOT) com...
Quote:
I have a SQL cluster running and would like to add an instance. What is
the procedure? I have different disks available for the new instance.



Geoff N. Hiten wrote:

You were good until the last sentence.
06-Nov-08

You were good until the last sentence.

You cannot share resources, including disk resources, between instances.
You get one instance per "Service or Application".

For a second instance, you will need new disks, a new network name, and a
new IP address.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"John Myren" <john.myren(@).hemnekraftlag.no> wrote in message
news:72118602-3571-4D9A-BB25-85B5A3A0BA23 (AT) microsoft (DOT) com...

Previous Posts In This Thread:

On Thursday, November 06, 2008 7:43 AM
john.myren wrote:

New Named SQL Server 2008 Instance in existing Cluster - HowTo?
How do we add a new Named Instance under Services and Applications for the
existing SQL 2008 Cluster? We have the default MSSQLServer installed and
working OK.

We want to share the same data disk's for both Instances. Is this
possible?

On Thursday, November 06, 2008 11:06 AM
Geoff N. Hiten wrote:

You were good until the last sentence.
You were good until the last sentence.

You cannot share resources, including disk resources, between instances.
You get one instance per "Service or Application".

For a second instance, you will need new disks, a new network name, and a
new IP address.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"John Myren" <john.myren(@).hemnekraftlag.no> wrote in message
news:72118602-3571-4D9A-BB25-85B5A3A0BA23 (AT) microsoft (DOT) com...


Submitted via EggHeadCafe - Software Developer Portal of Choice
EggheadCafe Stock Quote WebService
http://www.eggheadcafe.com/tutorials...k-quote-w.aspx

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.