SQL Server does not recognize new disk resource -- sql server clustering

Jon Goughnour
11/30/2004 1:09:02 PM

No, I missed that. Would I only need to take the SQL Server resource Offline
to do that or is there more to it?

[quoted text, click to view]

Jon Goughnour
11/30/2004 1:39:09 PM

Thanks for your help. I'll try this tonight.

[quoted text, click to view]

Tom Moreau
11/30/2004 3:38:19 PM

Have you made SQL Server dependent on this resource?

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com

[quoted text, click to view]
Hello,

I have a SQL Server 2000 cluster running on Win2K (2 HP ML530's on an HP
MSA1000 SAN - all 14 drives in one RAID array). I recently added some
unallocated disk space on the SAN as a new disk resource in the cluster.
The
MSA1000 doesn't support extended partitons so a new partition was created.
The disk resource is showing an Online status in Cluster Administrator and
Windows recognizes the new partiton, however, SQL server does not recognize
it. What did I do wrong and how can I fix it?

Thanks,

Jon

Tom Moreau
11/30/2004 4:13:41 PM

You'll need to take SQL offline, then add the dependency and bring SQL back
online.

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com

[quoted text, click to view]
No, I missed that. Would I only need to take the SQL Server resource
Offline
to do that or is there more to it?

[quoted text, click to view]

uttamkp NO[at]SPAM online.microsoft.com
11/30/2004 9:38:51 PM

The steps are documented in KB

INF: Creating Databases or Changing Disk File Locations on a Shared Cluster Drive on Which SQL Server 2000 was not Originally Installed
http://support.microsoft.com/?kbid=295732

I am cutting and pasting it for you.

To add a disk as a dependency to the SQL Server, the shared cluster disk must reside in the same group in the Cluster Administrator as the SQL Server resources.

To move the shared cluster disk, select the disk you want to move to the SQL Server group, and then right-click that resource. Click Move Group. After the disk is in the
same group in which the SQL Server resource resides, follow these steps to add it as a SQL Server dependency:
1. Open the Cluster Administrator.
2. Make sure that all the physical disk resources that contain SQL Server databases are in the same group as the SQL Server resource.
3. Right-click the SQL Server resource, and then bring the resource into an Offline state by clicking Bring Offline.
4. Right-click the SQL Server resource, and then click Properties.
5. Click the Dependencies tab.
6. Click Add to add the disk to the dependencies list for that resource.
7. Bring the SQL Server resource back online, and then put the SQL Server files on that shared cluster disk.

HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest
way to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : SQL Server does not recognize new disk resource