14,494 questions
![](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.
Restoring SQL Database issue
![](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)
Cai-Aaron Wing
1
Reputation point
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
SQL Server Other
{count} votes
-
![](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)
Robbie Varn 351 Reputation points2021-10-27T18:38:32.637+00:00 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)
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff2021-11-01T01:08:51.177+00:00 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
Sign in to comment
3 answers
Sort by: Most helpful
-
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2021-10-27T21:55:37.697+00:00 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. -
AmeliaGu-MSFT 14,006 Reputation points Microsoft External Staff
2021-10-28T03:11:43.663+00:00 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.