Post reply

Can we create database on clustered drives in sql server 2000 and sql server 2005

  • September 23, 2008 at 10:41 pm

    #123741

    Can we create database on clustered drives in sql server 2000 and sql server 2005 and please provide related documents reg this

  • September 24, 2008 at 1:07 am

    #876140

    What do you mean by 'clustered drive'?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

  • September 24, 2008 at 5:03 am

    #876223

    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.

  • September 24, 2008 at 5:11 am

    #876227

    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?

  • September 24, 2008 at 5:38 am

    #876251

    yes ur right its windows cluster only

    my question is can we create database on clustered drives

  • September 24, 2008 at 6:24 am

    #876285

    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

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply