Moving a SQL 2000 Database

What are the steps I need to take to move a SQL 2000
database from one physical drive to another on the same
machine?Look up sp_detatch_db and sp_attach_db in BOL... Or use All Tasks -> Detach
Database and All Tasks -> Attach Database in Enterprise Manager.
You'll basically just need to detach the database files, move them, then
re-attach them. Generally a fairly painless process... YMMV, so back up
first if possible!
"jeffs" <jeffs@.bumbleandbumble.com> wrote in message
news:02ef01c3a3cd$72a7d250$a301280a@.phx.gbl...
> What are the steps I need to take to move a SQL 2000
> database from one physical drive to another on the same
> machine?|||In addition to Adam's post:
Check out KB 224071.
--
Tibor Karaszi
"jeffs" <jeffs@.bumbleandbumble.com> wrote in message
news:02ef01c3a3cd$72a7d250$a301280a@.phx.gbl...
> What are the steps I need to take to move a SQL 2000
> database from one physical drive to another on the same
> machine?|||Have a look at KB article Q224071
--
RajiA
"jeffs" <jeffs@.bumbleandbumble.com> wrote in message
news:02ef01c3a3cd$72a7d250$a301280a@.phx.gbl...
> What are the steps I need to take to move a SQL 2000
> database from one physical drive to another on the same
> machine?