how to access more than 1 drive

how to access more than 1 drive

Post by dGhlIGJvbH » Sat, 18 Feb 2006 20:52:27


Hi

I have installed SQL 2000 on a server 2003 cluster. The 2003 servers are
able to access all the shared drives fine and I have tested reading and
writing from both nodes. However when I install SQL 2000 I am only able to
see 1 drive from within SQL. This is a problem as I want to split the DB and
Logs onto different drives.

Help please
 
 
 

how to access more than 1 drive

Post by Tom Morea » Sat, 18 Feb 2006 21:00:42

Add the appropriate drive to the SQL Server cluster group.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.


Hi

I have installed SQL 2000 on a server 2003 cluster. The 2003 servers are
able to access all the shared drives fine and I have tested reading and
writing from both nodes. However when I install SQL 2000 I am only able to
see 1 drive from within SQL. This is a problem as I want to split the DB
and
Logs onto different drives.

Help please

 
 
 

how to access more than 1 drive

Post by dGhlIGJvbH » Sat, 18 Feb 2006 21:46:03

Have done that although it was not like that when SQL was first installed. I
have since uninstalled SQL and then re installed into the same group as the
drives but it still only sees the one disk. Could this be due to their being
things left behind after the first uninstall? If so any clues as to how to
do a complete uninstall of SQL?

Thanks in advance
 
 
 

how to access more than 1 drive

Post by Rodney R. » Sat, 18 Feb 2006 21:54:10

Add the other drive(s) to the SQL Server Resource as a dependency.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.yqcomputer.com/ - Clustering Website
http://www.yqcomputer.com/
http://www.yqcomputer.com/ - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
 
 
 

how to access more than 1 drive

Post by Rodney R. » Sat, 18 Feb 2006 21:55:07

And add it as a dependency to the SQL Server resource.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.yqcomputer.com/ - Clustering Website
http://www.yqcomputer.com/
http://www.yqcomputer.com/ - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
 
 
 

how to access more than 1 drive

Post by dGhlIGJvbH » Sat, 18 Feb 2006 22:39:40

Thats done it thanks for your help