sql server msde: Moving Database From One Drive To Another -- sql server msde

Re: Moving Database From One Drive To Another

Hari Prasad
1/3/2007 6:38:45 PM

sql server msde: Hi,

Follow the below steps:-

1. Use the procedure SP_DETACH_DB <dbname> to detach the database.
2. Create a new folder in new drive and copy the MDF and LDF to new folder
3. Use sp_attach_db
'dbname','new_driveletter\folder\dbname.mdf','new_driveletter\folder\dbname.ldf'

See the below URL as well:-

http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071

Thanks
Hari

[quoted text, click to view]

Moving Database From One Drive To Another

Carol Anne
1/3/2007 11:50:18 PM

I've got MSDE 2000A running on a computer as part of an existing application.

The database is eating the hard drive at a prodigious rate, and I can't repartition
it (for other reasons), so I need to move the database to a different, larger
partition that is available. I'd like to do so with minimum downtime to
the production application.

Is there any step-by-step procedure you can share for moving an MSDE 2000
database from one drive to another?

--Carol Ann