Adding a LUN without taking SQL Cluster down?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Adding a LUN without taking SQL Cluster down?...

Adding a LUN without taking SQL Cluster down?

Rate Topic

Display Mode

Topic Options

Author

Message

Laszlo Acs

Posted Tuesday, September 01, 2009 9:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, August 03, 2012 7:49 AM
Points: 6, Visits: 25

Is it possible to add a LUN to a SQL Cluster without taking the cluster offline?

TIA -- Laszlo

Post #780821

rajdba

Posted Tuesday, September 01, 2009 10:54 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 12:09 PM
Points: 100, Visits: 393

Laszlo

What type of cluster is this, AA or AP?

Thanks
Raj

Post #780890

Laszlo Acs

Posted Tuesday, September 01, 2009 11:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, August 03, 2012 7:49 AM
Points: 6, Visits: 25

It's Active-Active. -- Laszlo

Post #780893

SQLRNNR

Posted Tuesday, September 01, 2009 3:17 PM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:07 PM
Points: 18,733, Visits: 12,332

This may not be precisely what you want or need.

We have in the past added a lun as a mount point in an already existing lun. This makes it immediately available for use (after permissions are applied). In this scenario we did not have to bring down the cluster.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #781112

Laszlo Acs

Posted Thursday, September 03, 2009 9:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, August 03, 2012 7:49 AM
Points: 6, Visits: 25

Thanks for helping - what we eventually did that day a couple of days ago was going to another machine that was not mission-critical so we could cycle SQL services and implement the new LUN and our recovery issue through it. This worked fine and our issue is no longer an item.

Bottom line - we never found a means of attaching a LUN to the SQL Server without turning off services and adding dependencies. Otherwise, even though Windows Explorer could "see" the added LUN, SQL could not - plain and simple. No way to force it, that I could find, on-the-fly...

-- Laszlo

Post #782273

The CosmicTrickster

Posted Wednesday, January 13, 2010 6:17 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:10 PM
Points: 2,605, Visits: 756

It's been my experience (and I've seen it noted elsewhere in the forums here) that that is not entirely true. If you don't create the dependency, you can't see the drive in any of the GUIs but if you were to run "BACKUP DATABASE [dbname] to disk = '<newdrive>:\folder' " it would work (assuming NTFS permissions had been set correctly of course). The same applies if you put the command in a scheduled task.

Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

Post #847292

« Prev Topic | Next Topic »

Permissions