SQL Server 2000 Drive selection

5 pts.
Tags:
Drive designations
SQL Server 2000
SQL Server 2000 Drive Designation
SQL Server Drive Designation
Windows XP
I have a software package (Pinnacle Studio 10) that installed a SQL Server 2000 database. When I first loaded the SQL software on the C drive it created a database on the D drive. I now need to create a database (or move the database) to a new H drive. How can I do this? Can I change the swap the drive designation D to H and H to D? I am running Windows XP home.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Open SQL Enterprise Manager and expand the Databases tree. Right click on the database name and select All Tasks, then select Detach Database. Move the physical files from the D drive to the H drive. Right click on databases and select All Tasks > Attach Database. Browse to the new location and select the mdf file. Click OK, then OK again (you may need to correct the path to the log file).

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following