Copy Database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Copy Database

I am trying to copy a database from server A to server B. I tried the "Copy Database" wizard and it failed at the job. Then, I decided to restore the .bak at the server B. However, the data files on server A resides on D drive while the backup file is looking for C drive. What should I do to get this database copied? Thanks
You have to use MOVE option in BACKUP. (Take a look in BOL) Or if you use Enterprise Manager, in tab options you can change the original folder D to the new one C.
Luis Martin
Moderator All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Thanks! The MOVE option works.