Please always state what version you are using.
You can do this with sp_detach_db and sp_attach_db. Please read about these
commands in the Books Online.
If you are SQL Server 2000, you perform a detach and an attach by right
clicking on the database in Enterprise Manager.
Basically, the steps are:
Detach the database
Move the files
Attaching the database, specifying the new file locations
SQL Server MVP
"Sender" <com> wrote in message