Having fun with moint points

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

> 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
>

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..
Same to all
Regards
Amish

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..Same to all
Regards
Amish

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..
Same to all
Regards
Amish

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..Same to all
Regards
Amish

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..
Same to all
Regards
Amish

Happy Holidays to you all

Been fun posting on some of these SQL newsgroups and receiving timely
responses that made my day.
Thanks to all who responded and also thanks to all the ones that ask
questions.
I only wish i could read the newsgroup postings every day
Anyways Happy Holidays everyone..Same to all
Regards
Amish