Should I configure the second sql instance to use same C:\ drive root directory path as the exiting Default instance?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Should I configure the second sql instance to...

Should I configure the second sql instance to use same C:\ drive root directory path as the exiting Default instance?

Rate Topic

Display Mode

Topic Options

Author

Message

sfar

Posted Tuesday, September 11, 2012 3:48 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 13, 2012 3:14 PM
Points: 4, Visits: 23

What are the guidelines for the the root directory path for a second sql server instance being added to the same server where a 'default' instance already exists with its root directory on the same C: drive?

What will happen if I, instead, use the E: drive for the root directory for the second instance?

Post #1357726

SQLRNNR

Posted Tuesday, September 11, 2012 3:58 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754, Visits: 12,337

The instance will function just fine.

I like to move my default path off of C in the first place. I also like to have a different path for each instance.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1357732

AndrewSQLDBA

Posted Tuesday, September 11, 2012 4:00 PM

Right there with Babe

Group: General Forum Members
Last Login: Yesterday @ 7:32 PM
Points: 796, Visits: 2,279

It does not matter where you let the SQL executable reside.

I never, ever use Drive C for anything. Not even the OS. I install all other instances on the same drive as the Default and then place the actual data files on the drives with the default instance system databases, but into their own respective directory.

I use one spindle for the executables, one spindle for the Data Files, one Spindle for the Log Files and one spindle for the Temp Database. For any really large database, or database that has high transactions, I place that one on its own spindle as well.

Andrew SQLDBA

Post #1357733

sfar

Posted Wednesday, September 12, 2012 8:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 13, 2012 3:14 PM
Points: 4, Visits: 23

But aren't there some 'shared' files/folders/etc. that will need to be updated (or written to) on the default instance's root directory when the second instance is installed?
So what happens to these shared files/folder/etc. if that second instance is installed on another drive?

Post #1357999

« Prev Topic | Next Topic »

Permissions