change disk

Hi,
I would like to change the destiantion disk of a database on sql7, because
free left space is to small for a maintenance operation.
What is the way, after installing a new biger secondary HD, to change
destination ?
Thanks
ManuEasiest is to use sp_detach_db and then sp_attach_db. I recommend that you
read KB 224071 which has some additional information about the process.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Manu" <info@.dr-ing.net> wrote in message
news:%23Xh5j0v%23DHA.2860@.tk2msftngp13.phx.gbl...
> Hi,
> I would like to change the destiantion disk of a database on sql7, because
> free left space is to small for a maintenance operation.
> What is the way, after installing a new biger secondary HD, to change
> destination ?
> Thanks
> Manu
>

change disk

Hi,
I would like to change the destiantion disk of a database on sql7, because
free left space is to small for a maintenance operation.
What is the way, after installing a new biger secondary HD, to change
destination ?
Thanks
ManuEasiest is to use sp_detach_db and then sp_attach_db. I recommend that you
read KB 224071 which has some additional information about the process.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Manu" <info@.dr-ing.net> wrote in message
news:%23Xh5j0v%23DHA.2860@.tk2msftngp13.phx.gbl...
> Hi,
> I would like to change the destiantion disk of a database on sql7, because
> free left space is to small for a maintenance operation.
> What is the way, after installing a new biger secondary HD, to change
> destination ?
> Thanks
> Manu
>

Change Cluster Disk Owner

I have an Active/Active cluster with Windows 2003 with SQL Server 2000. I
am trying to move the cluster disk T: owner to my other group.
I keep receiving the following error:
An error occurred attempting to change the group of the
Disk T: to 'Other Resource' Group. The cluster node is not the owner of the
group. Error ID:5016
I checked all cluster groups and they have both owners. I also checked and
there is no dependency on Disk T:
Please help me with moving Disk T: to the Other Resource Group.
Thanks,
You can only change ownership of a resource from the node that currently
both resource groups.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:BAFDEF6E-33BF-4C6B-9066-8CD9F5347325@.microsoft.com...
> I have an Active/Active cluster with Windows 2003 with SQL Server 2000. I
> am trying to move the cluster disk T: owner to my other group.
> I keep receiving the following error:
> An error occurred attempting to change the group of the
> Disk T: to 'Other Resource' Group. The cluster node is not the owner of
the
> group. Error ID:5016
> I checked all cluster groups and they have both owners. I also checked
and
> there is no dependency on Disk T:
> Please help me with moving Disk T: to the Other Resource Group.
>
> Thanks,
|||And the SOLUTION would be to create a new resource group ("FOO") with no resources in it. Move it to the same node as the group that owns the resource you want to move. Now you can move the resource into the FOO resource group.
Move the FOO resource group to the node that owns the group to which you'd like to move the resource. Now you can move the resource to its destination.
Remove the FOO group and you are done.
This, of course, is only necessary if you can't move both resources to the same node for some reason.
HTH
jg

Quote:

Originally posted by Geoff N. Hiten
You can only change ownership of a resource from the node that currently
both resource groups.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
> I have an Active/Active cluster with Windows 2003 with SQL Server 2000. I
> am trying to move the cluster disk T: owner to my other group.
> I keep receiving the following error:
> An error occurred attempting to change the group of the
> Disk T: to 'Other Resource' Group. The cluster node is not the owner of[/vbcol]
the
> group. Error ID:5016
> I checked all cluster groups and they have both owners. I also checked
and
> there is no dependency on Disk T:
> Please help me with moving Disk T: to the Other Resource Group.
>
> Thanks,

|||Joe,
Geoff is correct.
Make sure you both groups are on the same node.
Then from that node, move the T: drive into the other resource group.
You will of course need to make sure T: is not a dependency of any other
resources prior to moving it.
Hope that helps!
Donna Lambert
Microsoft PSS
SQL Server Support