Problem when restore database

Doaa Mohamed Rashad 0 Reputation points
2023-05-03T09:06:53.68+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,141 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,581 Reputation points
    2023-05-03T10:47:53.1133333+00:00

    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.


  2. Rahul Randive 9,011 Reputation points Microsoft Employee
    2023-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.

    0 comments No comments