Moving a database

[Dave]

I'm very new to SQL Server 2005, so please be kind.

We had a vendor in and they loaded their software and the database
that was created is sitting
on the root (c:) drive. On this server we have another drive where
the database should reside, is
there a way to move this database to the correct drive? Thank you for
any help that you could
provide.

Dave Schaeffer

[Erland Sommarskog]

Re: Moving a database

Dave (dave.schaeffer @gmail.com) writes:

I'm very new to SQL Server 2005, so please be kind.
>
We had a vendor in and they loaded their software and the database that
was created is sitting on the root (c:) drive. On this server we have
another drive where the database should reside, is there a way to move
this database to the correct drive? Thank you for any help that you
could provide.

You could try the Copy Database Wizard. Right-click the database in
Object Explorer, and select Tasks and then Copy Database in the
submenu. Select local server for both target and destination. Make
sure you select the attach/detach method (it's selected by default).
At one point you get a database-selection dialog. You can select Move here
instead of copy. Make sure that you have SQL Server Agent.

I will have admit that I give this advice with some hesitation. To wit,
the Copy Database Wizard is very buggy. But attach/detach in the same
server, is so simple so it cannot reasonably not fail. Personally, I
prefer to do this operation with backup/restore, but since you are
very new, you are probably more comfortable with the Wizard for now.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx