|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 --