My san disk is about to full and I can't add other database on it.

Question

My san disk is about to full and I can't add other database on it.

forsqlserver

SSCoach

Points: 18902
More actions
December 2, 2009 at 3:31 am

#140429

Dear,
My san disk is about to full and I can't add other database on it.
Now I want to add another SAN Disk on the existing cluster[active-active] how can I do it...?
Thanks

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Expose the LUN to the cluster, create a disk resource for it in cluster admin, make that resource a dependency of the SQL Service that will be using it.

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

forsqlserver SSCoach Points: 18902 More actions · Answer 2

Dear Gila...

Thanks..Actually this is a critical scenario and to make changes in a running scenario is risky.

Have u the steps one by one in GUI form or any help...

Thanks

forsqlserver SSCoach Points: 18902 More actions · Answer 3

I have tried to do this but I am getting error as:

TITLE: Microsoft SQL Server Management Studio

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

Create failed for Database 'tests'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476

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

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

Cannot use file 'Y:\tests.mdf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5184)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=5184&LinkId=20476

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

BUTTONS:

OK

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

Thanks

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 4

The new drive you have added to your system (Y Drive) is not yest added to the SQL Server Resource. If you have seen what Gail Shaw has replied, that is what you need to do.

Any way look at the following link.

How to: Add Dependencies to a SQL Server Resource

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

guptaajay1985 (12/2/2009)
Thanks..Actually this is a critical scenario and to make changes in a running scenario is risky.

It doesn't make the slightest difference how critical the situation is. You have to do the steps that I listed or SQL will not be able to use the drives. This isn't a set of suggested, but not required, steps. It's the required, documented process for adding a drive to a clustered SQL Server.

These are all (other than the first) done via a GUI, the Cluster Administration GUI. If you don't know how to use Cluster Admin, speak to whoever administrates the cluster.

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