Multiple instances SQL server 2000 - destination folders

Can someone clarify for me, if I were to install 2 named instances of
SQL server 2000, whether I must define 2 different destination folders
for the program files ?
Or can I leave the Program Files destination folder the same for both
instances [c:\program files\Microsoft SQL Server] ?
I am separating the data files in their own data file destination
directory [d:\...\microsoft sql server\data\name_of_instance1 and
d:\...\microsoft sql server\data\name_of_instance2
And also, will I need to run service packs for each named instance
separately ?
Yes, specify a different installation folder. There will be some shared
components though.
You have to install service packs/security patches/hot fixes for each
instance separately.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:hu8ie014lns9k5lrcgldb8erth0i2c0rn7@.4ax.com...
Can someone clarify for me, if I were to install 2 named instances of
SQL server 2000, whether I must define 2 different destination folders
for the program files ?
Or can I leave the Program Files destination folder the same for both
instances [c:\program files\Microsoft SQL Server] ?
I am separating the data files in their own data file destination
directory [d:\...\microsoft sql server\data\name_of_instance1 and
d:\...\microsoft sql server\data\name_of_instance2
And also, will I need to run service packs for each named instance
separately ?
|||just specify the \Program files\Microsoft SQL Server will be enough , it
will create a directory below there called MSSQL$<INSTANCEName> (default
will go in MSSQL).
re Service Packs , yes you need to apply seperately for each instance,
although certain components asre common across instances - ie MDAC and Full
Text Search
cheers
Andy
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:hu8ie014lns9k5lrcgldb8erth0i2c0rn7@.4ax.com...
> Can someone clarify for me, if I were to install 2 named instances of
> SQL server 2000, whether I must define 2 different destination folders
> for the program files ?
> Or can I leave the Program Files destination folder the same for both
> instances [c:\program files\Microsoft SQL Server] ?
> I am separating the data files in their own data file destination
> directory [d:\...\microsoft sql server\data\name_of_instance1 and
> d:\...\microsoft sql server\data\name_of_instance2
> And also, will I need to run service packs for each named instance
> separately ?
|||Okay, Andy's response is precise, for your first question :-)
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OGyegcnYEHA.2456@.TK2MSFTNGP10.phx.gbl...
Yes, specify a different installation folder. There will be some shared
components though.
You have to install service packs/security patches/hot fixes for each
instance separately.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Citizen" <citizen_NOSPAM@.hotmail.com> wrote in message
news:hu8ie014lns9k5lrcgldb8erth0i2c0rn7@.4ax.com...
Can someone clarify for me, if I were to install 2 named instances of
SQL server 2000, whether I must define 2 different destination folders
for the program files ?
Or can I leave the Program Files destination folder the same for both
instances [c:\program files\Microsoft SQL Server] ?
I am separating the data files in their own data file destination
directory [d:\...\microsoft sql server\data\name_of_instance1 and
d:\...\microsoft sql server\data\name_of_instance2
And also, will I need to run service packs for each named instance
separately ?
|||On Mon, 5 Jul 2004 11:03:05 +0100, "Andy Ball"
<andy.ball@.remove4spam_greenfell.com> wrote:

>just specify the \Program files\Microsoft SQL Server will be enough , it
>will create a directory below there called MSSQL$<INSTANCEName> (default
>will go in MSSQL).
>re Service Packs , yes you need to apply seperately for each instance,
>although certain components asre common across instances - ie MDAC and Full
>Text Search
>cheers
>Andy
>
That's correct! Thanks for such a fast reply. I just finished checking
it on a test server! SQL server handles this just fine.