Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Administering » Can we create database on clustered drives in...
Add to briefcase

Can we create database on clustered drives in sql server 2000 and sql server 2005 Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
anand-861974
Posted Tuesday, September 23, 2008 10:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 16, 2012 11:45 AM
Points: 12, Visits: 159
Can we create database on clustered drives in sql server 2000 and sql server 2005 and please provide related documents reg this
Post #574891
GilaMonster
Posted Wednesday, September 24, 2008 1:07 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 37,744, Visits: 30,025
What do you mean by 'clustered drive'?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #574929
anand-861974
Posted Wednesday, September 24, 2008 5:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 16, 2012 11:45 AM
Points: 12, Visits: 159
here with detail explanation.
i have one active sever with drives(ex: c ,d)and passive server with drives(ex:c) so when active sever fails it failover to passive server along with the drive d(which is clustered) where passive server will become active now and acess the drive d for some data.

clustered drive means the drive which is shared for both the servers.
iam providing info acc to my knowledge please let me know i any thing is wrong.

and also help me how to find sever which is active.
Post #575038
DNA_DBA
Posted Wednesday, September 24, 2008 5:11 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:53 AM
Points: 2,374, Visits: 1,947
I guess that is a Windows cluster. If so, yes you can install SQL 2000 or 2005 on it. For 2000 you will need Enterprise Edition, for 2005 you can use Standard Edition. You can see which is the active node by looking in Cluster Administrator. If it is not a Windows cluster, what is it?
Post #575044
anand-861974
Posted Wednesday, September 24, 2008 5:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 16, 2012 11:45 AM
Points: 12, Visits: 159
yes ur right its windows cluster only
my question is can we create database on clustered drives
Post #575076
DNA_DBA
Posted Wednesday, September 24, 2008 6:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:53 AM
Points: 2,374, Visits: 1,947
The answer is yes. On the cluster you will only have the choice of putting the databases on the clustered drives, SQL Server won't see any other disks
Post #575119
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.