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 SchaefferDave (dave.schaeffer@.gmail.com) writes:
Quote:
Originally Posted by
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@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
