Re: Multiple instances SQL server 2000 - destination folders

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Citizen (citizen_NOSPAM_at_hotmail.com)
Date: 07/05/04


Date: Mon, 05 Jul 2004 12:52:07 +0200

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.