Create new SQL 2008 database in external drive

15 pts.
Tags:
External Disk Drives
SQL Database
SQL Express
SQL Express 2008
My local server using SQL 2008 Express is running low on disk space. Is it possible to create new databases or move a database to an external drive? If so, how is it done, configuration wise? Thanks.
ASKED: September 20, 2011  4:00 PM
UPDATED: March 31, 2012  3:51 PM

Answer Wiki

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

Yes you can move the database. In Management Studio right click on the database and select all tasks then detach database. Then move the files, then you can attach the database by right clicking on “Databases” in the object explorer of Management Studio and select all tasks then attach database. Find the file and select attach.

Keep in mind that if you put the database on an external drive it’ll be a lot slower than if it is on your internal disk.

Discuss This Question: 2  Replies

 
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
  • HermanHermit
    Thanks, MrDenny. But I need to copy only one database (the rest stays in the internal drive) and create new ones in an external drive with the option to use all databases from both sources (internal/external). How can I make this work, if at all possible?
    15 pointsBadges:
    report
  • HermanHermit
    [...] If you want to create a new SQL 2008 database in external drive, Mrdenny has some ideas for [...]
    0 pointsBadges:
    report

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