Home > IT Answers > Storage > Create new SQL 2008 database in external driv...
HermanHermit
15 pts.
 Create new SQL 2008 database in external drive
External Disk Drives, SQL Express, SQL Express 2008, SQL Database
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: Sep 20, 2011  4:00 PM GMT
UPDATED: March 31, 2012  3:51:57 PM GMT
RELATED QUESTIONS
Mrdenny
63,630 pts.
Answer Wiki:
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.
Last Wiki Answer Submitted:  Sep 21, 2011  8:36 AM (GMT)  by  Mrdenny   63,630 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

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?

HermanHermit
 15 pts.
 

[...] If you want to create a new SQL 2008 database in external drive, Mrdenny has some ideas for [...]

The Most-Watched IT Questions: October 4, 2011 - ITKE Community Blog
 0 pts.