Posted by Stu on 08/17/06 18:24

the safest method is to do a backup and restore; however, you can
detach, move, and reattach (usually) with no problems. Of coruse,
before doing any operation such as this, you should take a backup first
(which is why the first method is recommended).

Stu


Mark D Powell wrote:
> 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 --

[Back to original message]