Where do you put a share? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Where do you put a share?

Author

Topic

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2004-05-24 : 08:33:33

Environment:
Windows Server 2003.
2 node Cluster single instance of SQL Server 2K sp3a.
1 SAN.

Cluster groups are:
- Cluster group with its own default resources.
- Oracle group with its own resources.
- SQL Server group with its own resources (Server,services,disks,ip address....)
Disk v:\ is for SQL Server databases
Disk w:\ is for SQL Server logs
Disk x:\ is for SQL Server backups.

SO now I have to create a shared folder where the clients need to connect in order to launch the program (executable file *.exe) and maybe tomorrow I will also need to create others shared folders where to put others executable.
Questions:
1)Is it correct to create theses shared folders in the SQL Server group?
2) In wich one of the tree disks?
3) If I have 20 differents programs with differents security will I end up in having a SQL Server group with 20 different resources (file shares)?
Please advise.
Kind regards.
Franco

Franco

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-05-24 : 09:02:39

Hey Franco. I know I answered this on another forum, but again you need to build more LUNs on the SAN for these shares. You don't want to use your SQL Server LUNs for file shares, especially if they are going to be launching executables from them.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2004-05-26 : 04:12:58

Thank you for aour answer.
The problem now is this:
I have 2 file share cluster resources (normal share A and B) in one cluster group.
Now I realize that I need to create many other share on the cluster and so I have created a new file share resource (C) for all the users.
This resource is defined as "share subdirectories" and not as a "normal share" and it is not visible by users because I put a $ sign at the end of the name.
I would like to have this and only this file share in the group.
I would like to delete, from cluster administrator, the first 2 share (normal share A and B) and put them under the C share.
Is it possible and how can I achieve this?
Please advise.

Franco

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources