dbTalk Databases Forums  

Having fun with moint points

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Having fun with moint points in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Hans de Bruin
 
Posts: n/a

Default Having fun with moint points - 02-25-2005 , 09:13 AM






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?

--
Hans


Reply With Quote
  #2  
Old   
Mike Epprecht (SQL MVP)
 
Posts: n/a

Default RE: Having fun with moint points - 02-25-2005 , 09:49 AM






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

"Hans de Bruin" wrote:

Quote:
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?

--
Hans



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.