This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
Hi There,
I am having an issue with restoring a database over another database. So our setup is that we have clients, and they have a live database and a test database. Occasionally we will need to copy the live one over the top of the test one. When trying to restore the live over test, we always will have to head to the files tab, and re-allocate the files. However it is only with one specific database which this happens with. I have identified that the issue is with the live database, however I can't work out how to fix it? Any advice would be appreciated.
Example of issue
Example of how it should be with a different database
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 71%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Are you saying that you are expecting to see the "Test" inserted into the "Restore As" and you are not seeing this, and, you are having to add it manually to get the restore to run? Or, are you getting some type of restore error after you manually enter in the "Test" verbage into the physical file name?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi CaiAaronWing-1844,
How are things going? Does the answer help you?
Please feel free to let us know if you have any other question.
If you find any post in the thread is helpful, you could kindly accept it as answer.
Best Regards,
Amelia
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
The screen shots are just of the file named which were backed up. There is nothing to "fix" for the file names in the backup.
Rather than using the UI, use the RESTORE command directly. The form is
´´
RESTORE DATABASE db FROM DISK = '<backuppath>
WITH MOVE '<logicalname1>' TO PATH = '<path1>',
MOVE '<logicalname2>' TO PATH = '<path2>',
MOVE '<logicalname3>' TO PATH = '<path3>'
You do this once and save the script.
Hi CaiAaronWing-1844,
Welcome to Microsoft Q&A.
Could you please check and make sure the following two important potions in Restore database page-> Options tag are unchecked?
In my little test, once these two options are unchecked, we can restore database over another database successfully.
Best Regards,
Amelia
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.