Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.