dbTalk Databases Forums  

missing drives

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


Discuss missing drives in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mirna
 
Posts: n/a

Default missing drives - 01-27-2004 , 01:06 PM






The servers are W2003 Enterprise
SQL is 2000 Ent sp3a
Active/Passive

I just finished configuring the cluster and it looks fine
except SQl does not see all drives. In other words when
trying to create the database in enterprise manager
server does sees only one drive. It bahaves the same when
trying to backup the database. What could be wrong ?

Thanks for your time,
Mirna

Reply With Quote
  #2  
Old   
Geoff N.Hiten
 
Posts: n/a

Default Re: missing drives - 01-27-2004 , 01:12 PM






Create a cluster resource for the drive. Then you must add the drive to the
resource group for your SQL Virtual server. Finally, you must change the
dependancies so that SQL server is dependant on the new drive resources.
SQL can then use the drives as database storage.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

"Mirna" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
The servers are W2003 Enterprise
SQL is 2000 Ent sp3a
Active/Passive

I just finished configuring the cluster and it looks fine
except SQl does not see all drives. In other words when
trying to create the database in enterprise manager
server does sees only one drive. It bahaves the same when
trying to backup the database. What could be wrong ?

Thanks for your time,
Mirna



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.