Install New Instance/ Store Data & Log Files in existing drive

Giganews Newsgroups
Subject: Install New Instance/ Store Data & Log Files in existing drive
Posted by:  Caroline (Caroline@community.nospam)
Date: Wed, 21 Feb 2007

Hello,

I need to install a new instance of SQL Server 2000 on a cluster.
Currently, we have three instances.  Each instances stores program files on
the E:\ Drive.  Each instance has its own drive for data and another for
logs.  However, there is no more unallocated space on the array to create
another partitioned drive.

My question is:  If I create the new instance, can I store the data and log
files on an existing drive?  Are there any performance or overhead costs that
should be considered?

Thank you,

Caroline

Replies