Post reply

Can we add the disk on the fly in SQL Server cluster ?

  • July 20, 2015 at 12:03 am

    #319112

    Hi Experts,

    Wind 2012 R2 Std.

    SQL Server 2012 Ent. Edition.

    2 node Active/Passive cluster.

    A new LUN was just added to cluster for sql db backups.

    We need to add that disk in the SQL cluster and modify the backup jobs to place the backup files in the new drive.

    Do we need downtime for this activity ? Can we add the disk on the fly in SQL Server cluster ?

    Thanks in advance.

    San.

  • July 20, 2015 at 12:11 am

    #1813576

    If the disk is already added to the server it should reflect under disk management in the MMC snap in. In which case it will be available as a cluster resource and you can simply add it via the cluster manager. I cant remember if the server needs to be restarted but i doubt it.

    Jayanth Kurup[/url]

  • July 20, 2015 at 4:31 am

    #1813614

    Hi Jayanth,

    Thanks, added the disk and changed the resource group also to SQL Server.

    I don't see any issues as such and is visible everywhere. The system is live now, hence couldn't failover and test.

    Keeping an eye on it. Thanks again.

    San.

  • July 20, 2015 at 9:28 am

    #1813682

    Windows 2003 used to require a restart of the clustered sql server resource when adding a disk as a dependency, Windows 2008 onwards doesnt

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 20, 2015 at 9:41 pm

    #1813767

    OK. Thanks Perry.

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

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