How do you move a 7.0 database 1

[JeffMachine]

I need to move some databases from one drive to another because the drive is filling up. I've seen some similiar threads on this subject but none I've found relate to SQL 7.0.

The first step I've seen is to detach the database, but when I try that thru Enterprise manager there is no option to detach. I'm clicking on the database and then selecting All Tasks.

 

[gmmastros]

You'll have to detach manually. Just make sure you are not connected to the database that you are trying to detach.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_da-di_83fm.asp

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[JeffMachine]

Thanks, that worked. I was afraid the process may be different when the detach option wasn't available and I didn't want to try it without confirming the right steps.