August 27, 2008 at 11:30 am
Hi,
In implementing Active/Passive/Active clusteing we have nodes like dba1,dba2,dba3.
dba1 Active-node1 has one instance and have groupA with disks D - Primary data files, E-Secondary data files, F - Log files, T-Temporary db files K - Backup files).
dba2 Active-node3 has one instance and have groupB with five drive letters (G- Primary data files, H-Secondary data files, I- Log files, S-Temporary db files J - Backup files). Passive-Node2 is the passive node.
for installing second failover instance an node1(dba1) we choose the Drive letters D,E,F,T but it not allowing us to like that. If this is the case when we want install 25 failover instances we are out of drive letters!!!!!!(say like A to Z drive letters are already used for 3 failover instances).
So what is the solution for this?
Thanks
Madhu
August 27, 2008 at 12:03 pm
August 27, 2008 at 12:24 pm
So I haven't done this, but I imagine you could set up a directories like these:
d:\SqlInstances\InstanceN\Data
d:\SqlInstances\InstanceN\Logs
d:\SqlInstances\InstanceN\System
d:\SqlInstances\InstanceN\Install
Then create mount points in each one that point to your actual san devices - or whatever you are using.
In XP the command to mount is this:
mountvol d:\SqlInstances\InsanceN\Data \\?\Volume{this is a unique disk signature-3787-11db-abb0-806d6172696f}
Anyway, here is another thread on this - http://www.sqlservercentral.com/Forums/Topic526351-146-1.aspx
August 27, 2008 at 12:35 pm
Is that correct that the sql server 2005 does not support mount points in clustering?
August 30, 2008 at 6:24 pm
SQL Server Supports Mount Points In Clustered environment
Go through the Link which mentioned above post for details
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply