Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can we create database on clustered drives in sql server 2000 and sql server 2005 Expand / Collapse
Author
Message
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
Posted Wednesday, September 24, 2008 1:07 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 42,432, Visits: 35,486
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
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
Posted Wednesday, September 24, 2008 5:11 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:59 AM
Points: 2,609, Visits: 2,225
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
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
Posted Wednesday, September 24, 2008 6:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:59 AM
Points: 2,609, Visits: 2,225
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