Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

share|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. – the-wabbit Jun 10 '11 at 9:24

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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