14,501 questions
Where is the folder "empty". If you use the SSMS GUI for restore, then the backup file must have the file extension ".bak", otherwise you have to use plan T-SQL for the restore.
Problem when restore 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(281.6, 14.000000000000002%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Doaa Mohamed Rashad
0
Reputation points
When I restore database i don't find exit file in file backup and I put file to database in folder backup the folder is empty
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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-05-04T06:08:06.2766667+00:00 You can take a look at the answers below. If it can help you, please accept it.
-
Anonymous
2023-05-10T08:33:37.22+00:00 We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
-
Anonymous
2023-06-02T08:27:41.1766667+00:00 We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Sign in to comment
2 answers
Sort by: Most helpful
-
Olaf Helper 47,441 Reputation points2023-05-03T10:47:53.1133333+00:00 -
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2023-05-03T21:54:56.3466667+00:00 In addition to Olaf's post, keep in mind that SSMS looks the folders on the machine where SQL Server is running, and not your own machine. (As SQL Server cannot access the files on your computer. With the one exception that you have a local SQL Server instance on your computer.)
Sign in to comment -
-
![](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(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RahulRandive 10,486 Reputation points Volunteer Moderator2023-05-03T12:16:11.83+00:00 Thanks for your question.
Could you kindly provide more details and background regarding the issue? Specifically, which version of SQL Server are you encountering the problem with when restoring the database.
Is it a PaaS SQL Server or an IaaS/On-premise setup.
Additionally, it would be helpful if you could share the restore command and, if possible, a screenshot.
Looking forward to hear from you.