This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
You can take a look at the answers below. If it can help you, please accept it.
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.
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.
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.)
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.