Post reply

Changing Database Path - Local Disk Not Showing

  • June 11, 2009 at 8:59 am

    #210841

    I'm a SQL n00b and our DBA's have no clue... lovely isn't it 😉

    Okay so here is the issue. When creating or altering an existing database to change the file paths the DBA's are selecting the button and only one local disk is showing up and not the other 4-6 local disks... They want to change the log path but are unable to see the other disks...

    Any help appreciated, screen shot attached

  • June 11, 2009 at 9:04 am

    #1008054

    Is this a cluster and is that drive a resource dedicated to that instance? If not then it can't use it / see it.

    Aside from that I have no clue. :w00t:

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • June 11, 2009 at 9:04 am

    #1008056

    This problem can indicate that the user that SQL Server instance is running under doesn't have privliges to write on the other disks.

    Oded

    www.dbsnaps.com

    www.orbiumsoftware.com

  • June 11, 2009 at 9:10 am

    #1008065

    Both the nodes are clustered...

    After adding the new SAN disk both nodes are unable to see them in the management studio when changing log path.

  • June 11, 2009 at 9:25 am

    #1008085

    In addition, all local disks have identical security permissions

  • June 11, 2009 at 9:28 am

    #1008086

    Did you add the new disk as a clustered resource? I'm not sure it shows up automatically.

  • June 11, 2009 at 9:41 am

    #1008104

    Yes the new disks were added as cluster resources in there assigned group

  • June 11, 2009 at 10:14 am

    #1008126

    Okay all... thank you very much for your time but I figured it out...

    It was a resource configuration issue.

    Old Settings:

    SQL Server (INST) Resource

    - Dependencies

    --- Disk

    --- SQL Network Name (INST)

    New Settings:

    SQL Server (INST) Resource

    - Dependencies

    --- Disk

    --- Disk

    --- Disk

    --- SQL Network Name (INST)

    I found that in order for that instance to think/see the local disk (ownership) you need to add it as a dependent resource; same goes for Analysis Services.

    I then took the resource group offline/online and they showed up...

    Thanks for everyones efforts...

  • June 11, 2009 at 10:18 am

    #1008132

    Yeah, sorry I wasn't clearer earlier but the dependency issue is what I was trying to convey. Sorry about that and glad you were able to figure it out.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 9 posts - 1 through 8 (of 8 total)

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