up vote 2 down vote favorite
share [g+] share [fb]

I'm new to MS SQL Server 2008.

I have a database back up which I've restored using MSSMS. SO right now the database file is running somewhere from my localhost. Is there a way for me to move the database file to an external drive and have it run from there?

link|improve this question
90% accept rate
feedback

1 Answer

up vote 2 down vote

You will have to detach the database, move the mdf and ldf files to the external database, then attach the database.

Any reason why you want to run a database off of an external drive? The performance will suffer.

link|improve this answer
Performance will not necessarily suffer - there are eSATA drives and RAID enclosures which can deliver just as much as similar internal drive configuration. But reliability might - disconnecting an external drive is so much more easy. – syneticon-dj Jun 10 '11 at 9:24
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.