Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 476
  • Last Modified:

sp_detach_db question

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:
sp_detach_db 'sigxp1'

Also tried:
sp_detach_db'sigxp1'
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?
0
ClareSnyder
Asked:
ClareSnyder
1 Solution
 
ClareSnyderAuthor Commented:
OK - I figured it out.
Command given was incomplete.

I ran sp_detach_db @dbname='sigxp1' and it worked. I turned on the results pane and it told me it ddetached - and I could move the data.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now