dbTalk Databases Forums  

Add new instance in SQL 08 Cluster Environment

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


Discuss Add new instance in SQL 08 Cluster Environment in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Amirullail
 
Posts: n/a

Default Add new instance in SQL 08 Cluster Environment - 01-29-2009 , 10:31 PM






Hi George and the rest

I'm planning to add another instance. My previous instance name is
"MSSQLSERVER"
So in a cluster environment, i'm planning to add this new instance by using
a different shared storage. I have another 4TB SAN Storage to be add in the
cluster environment.
So my question is :
Which task do i need to do first? Add storage or add new instance?

Currently my cluster name is "DBPCLUSTER.dbpmain.gov.my. So from there, can
i start from to "add a disk" from "Storage"? My existing Disk are :
1. Witness Disk in Quorum - Cluster Disk 3 (Volume G:NTFS)
2. DBPCLUSTERDtc - Cluster Disk 1 (VOLUME E:NTFS)
3. SQL Server (MSSQLSERVER) - Cluster Disk 2 (Volume F:NTFS)


Reply With Quote
  #2  
Old   
Amirullail
 
Posts: n/a

Default RE: Add new instance in SQL 08 Cluster Environment - 01-29-2009 , 10:57 PM






I want to add something :

Actually what is the best practice in this below scenario? Which are the
best practice in clustering environment ? Is't with one instance or more than
1 instance? i already have default instance name but as per below scenario,
i want to add bigger storage for another database....

"Amirullail" wrote:

Quote:
Hi George and the rest

I'm planning to add another instance. My previous instance name is
"MSSQLSERVER"
So in a cluster environment, i'm planning to add this new instance by using
a different shared storage. I have another 4TB SAN Storage to be add in the
cluster environment.
So my question is :
Which task do i need to do first? Add storage or add new instance?

Currently my cluster name is "DBPCLUSTER.dbpmain.gov.my. So from there, can
i start from to "add a disk" from "Storage"? My existing Disk are :
1. Witness Disk in Quorum - Cluster Disk 3 (Volume G:NTFS)
2. DBPCLUSTERDtc - Cluster Disk 1 (VOLUME E:NTFS)
3. SQL Server (MSSQLSERVER) - Cluster Disk 2 (Volume F:NTFS)


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

Default Re: Add new instance in SQL 08 Cluster Environment - 02-02-2009 , 01:56 PM



Storage first, since you have to "anchor" an instance to one or more disks.

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



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

Quote:
I want to add something :

Actually what is the best practice in this below scenario? Which are the
best practice in clustering environment ? Is't with one instance or more
than
1 instance? i already have default instance name but as per below
scenario,
i want to add bigger storage for another database....

"Amirullail" wrote:

Hi George and the rest

I'm planning to add another instance. My previous instance name is
"MSSQLSERVER"
So in a cluster environment, i'm planning to add this new instance by
using
a different shared storage. I have another 4TB SAN Storage to be add in
the
cluster environment.
So my question is :
Which task do i need to do first? Add storage or add new instance?

Currently my cluster name is "DBPCLUSTER.dbpmain.gov.my. So from there,
can
i start from to "add a disk" from "Storage"? My existing Disk are :
1. Witness Disk in Quorum - Cluster Disk 3 (Volume G:NTFS)
2. DBPCLUSTERDtc - Cluster Disk 1 (VOLUME E:NTFS)
3. SQL Server (MSSQLSERVER) - Cluster Disk 2 (Volume F:NTFS)



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.