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
>