dbTalk Databases Forums  

How to upgrade from single instance to multi instances

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


Discuss How to upgrade from single instance to multi instances in the microsoft.public.sqlserver.clustering forum.



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

Default How to upgrade from single instance to multi instances - 12-03-2003 , 04:43 AM






Hi,
I have a SQL2K cluster (with Windows 2000 Advanced Server)
with a single instance.
I would like to add a second instance, and I'm asking what
are the correct steps to perform in order to not disrupt
my existing DB.
Another question:
Is it necessary to add network board to my cluster to
configure the second virtual server ?
Thanks in advance,
Chiara

Reply With Quote
  #2  
Old   
Linchi Shea
 
Posts: n/a

Default Re: How to upgrade from single instance to multi instances - 12-03-2003 , 06:45 AM






Just run the SQL2000 setup and add another virtual server and named instance
(or default instance if the default instance not already installed). The
SQL2000 setup will copy all the SQL2000 binaries (minus some shared
utilities) to a different directory tree. This new instance will require at
least one physical disk separate from the disk(s) already used by the first
instance. You need to have this physical disk resource in a separate
resource group before starting the install.

It's pretty much just following the GUI prompt for installing a new SQL2000
instance in a cluster. Do remember to apply the latest service pack (SP3a)
after the install.

It would not be a common practice to add any more network card to install
another instance. You should have all the network cards you need before you
even install the first instance.

--
Linchi Shea
linchi_shea (AT) NOSPAMml (DOT) com


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

Quote:
Hi,
I have a SQL2K cluster (with Windows 2000 Advanced Server)
with a single instance.
I would like to add a second instance, and I'm asking what
are the correct steps to perform in order to not disrupt
my existing DB.
Another question:
Is it necessary to add network board to my cluster to
configure the second virtual server ?
Thanks in advance,
Chiara



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.