INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...The level of expertise is awesome. The nature in which people respond is professional helpful and not the least condescending. I can't say that for most forums..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > MIS/IT > Operating Systems - Hardware Independent > Microsoft: Microsoft Cluster Server (MSCS) Forum

Move a resource between groups

Read More Threads Like This One

domw001 (IS/IT--Management)

21 Mar 07 9:16

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 (Programmer)

21 Mar 07 14:29

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)
noevil
http://www.mrdenny.com

domw001 (IS/IT--Management)

27 Mar 07 3:42

Thanks for your advice. It works fine.

D.

mrdenny (Programmer)

27 Mar 07 22:26

No problem.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Microsoft Cluster Server (MSCS)