Restore database from different server 1

[Jimmy24]

Dear Sir or Madam,

I need to perform a full database restore to database D1 on Server SQL Server US1. I need to get my backup "D1_backup.dmp" from Server US2. Can you please provide me some assitance with the syntax. I appreciate your assitance in advance. Thanks James

RESTORE DATABASE D1
FROM \\US2\backups\'D1_backup.dmp'

 

[ptheriault]

You need to supply the MOVE option so the restore will place the data files on the different file path.

- Paul
- If at first you don't succeed, find out if the loser gets anything.