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
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thanks! The MOVE option works.

]]>