Solved

sp_detach_db  question

Posted on 2008-06-12
1
456 Views
Last Modified: 2012-06-21
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
Comment
Question by:ClareSnyder
1 Comment
 
LVL 1

Accepted Solution

by:
ClareSnyder earned 0 total points
ID: 21768979
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
listing SQL login names of valid databases 2 20
SQL Log size 3 17
changing page verifacation 1 26
MS SQL Delete Duplicate Rows Only 2 16
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question