Best way to move datafile from C drive to D

Giganews Newsgroups
Subject: Best way to move datafile from C drive to D
Posted by:  Mark D Powell (Mark.Powe…@eds.com)
Date: 17 Aug 2006

I obviously did not search the archives on the right terms so what is
the easiest and fastest way to move a 3G database from a nearly full C
drive to the nearly empty D drive that should have been used.

I could back it up, drop it, recreate it using the D drive, and restore
it but it seems like there should be a way to just move the datafile
and use if from the new location.

I am thinking that detatch/attach is the best method, but I would like
confirmation or suggestions on how to proceed or things to be aware of
when using this method.

-- Mark D Powell --

Replies