2

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?

1 Answer 1

2

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.

1
  • 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, 2011 at 9:24

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .