Move a resource between groups

[domw001]

A customer of mine has installed SQL 2005 on a cluster.

The cluster has 3 resource groups

Quorum: Disk Q:
SQL Group: Disk E:
Data Group: Disk F:

The SQL data files are on SQL Group (E
The VSQL resources are on Data Group (F

Why???? I dont know.

My problem is if i need to rebuild the SQL databases due to a failure, the process bombs out because the VSQL resources are not in the same group as the SQL data files.

If I move the VSQL resource from Data Group to SQL Group it works, however ALL resources in Data Group are moved too.

Is it possible to move selected resources between groups?

 

[mrdenny]

To move resources between groups you have to completly remove all dependencies from the resource.

If SQL needs to access the F drive then it needs to be in the same resource group that the SQL Server will be in.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[domw001]

Thanks for your advice. It works fine.

D.

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com