We are running an SQL (2000) database that is growing very quickly and our data drive is too small. I have installed a new 140gb drive on the server and need to move the database to the new drive. Using SQL Query Manager I have attempted todetach the database using the following command:
I get no response (am I supposed to?) and when I try to copy and paste the data diles I get an error saying they are in use.
What am I missing?