SQL Server 2nd Instance Installation

[Apollo21]

I am in the midst of putting up a second instance of SQL Server. I have come to the screen where it is asking for Setup Type. I have selected 'typical'.
On the same screen it is asking for destination folders. The default folders are 'C:\Program Files\Microsoft SQL Server'. Both program files and data files get put here.
My question is - do I need to change the destination files because I am putting on a second instance or does the install take steps to prevent interfering with the initial installs Data and Program files.(The first install used the same destination folders as it is asking for the second install.)

Thank you in advance.

 

[SQLBill]

They can go in the same folder. SQL Server will take care of keeping it separate. At least it does so for us.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

Correct you can specify the same folder. SQL will take care of the rest.

With SQL 7/2000:
For example if you tell it to use D:\MSSQL\ for the install folder for the default instance SQL Server will use D:\MSSQL\MSSQL\ as the actual folder for the files. If you install an instance named SQLEXPRESS and tell it to use D:\MSSQL\ for the install folder it will use D:\MSSQL\MSSQL$SQLEXPRESS\ as the actual folder for the files.

With SQL 2005:
If you tell SQL to use D:\MSSQL\ it will use D:\MSSQL\MSSQL.1\ for the first instance, D:\MSSQL\MSSQL.2\ for the second instance, etc.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com