Having fun with moint points

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hans de Bruin - 25 Feb 2005 15:11 GMT

To keep the number of driveletters to a minimum, have
the same directory structure on the instances and do
something with disks and performance I tried this:

MSSQL$I1\Data
\Data1 <- mount point
\Tlog
    \Backup
\Backup1 <- mount point

MSSQL$I2\Data
\Data1 <- mount point
\Tlog
    \Backup
\Backup1

MSSQL$I3\Data
\Data1
\Tlog
    \Backup
\Backup1

And ran into the SQL Setup does not support mount points
bug or feature. So I added driveletter to the mounted disk.
I am still thinking off using the mount points next to the drive
letters. Are the any other issues or disadvantages I should be
aware off?

Signature

Hans

Reply to this Message

Mike Epprecht (SQL MVP) - 25 Feb 2005 15:49 GMT

Hi

Have you looked at http://support.microsoft.com/kb/819546/en-us "SQL Server
2000 support for mounted volumes"?

On non-clustered systems, the base drive needs a drive letter.

Regards
Mike

> To keep the number of driveletters to a minimum, have
> the same directory structure on the instances and do
[quoted text clipped - 23 lines]
> letters. Are the any other issues or disadvantages I should be
> aware off?

Reply to this Message