Adding new disk drive for SQL server.

  • My sql server is working in Cluster mode and my database disk is runing low on Disk space. I need to move my Dump devices to a new drive connected to my Cluster.

    I can see and access the new drive no problem, I can copy my dump devices to the new location, but when I try to create a new device on the new drive using Interprise Manager, the application does not see the drive, it only see  the drive where SQL server is installed. How can I change that.

  • Was the new drive added as a cluster resource?

    If so:  I have seen similiar behavior, just type the full path name in the dialog boxes and it will see/use the drive.  You just can't use the GUI.

  • If you set up the Physical Disk resource for your new drive a dependency of the SQL Server resource in the resource group, EM should present the drives as part of the clustered server.

     

     

  • Beware though ... you are looking at an outage ... you most bring the instance down to add a new disk resource.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • Are the new drives manged by Vertias volume manager?

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

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