14,494 questions
The service account running Sqlserver need file read access to the file it is restoring. Also the the file must be local on the Sqlserver host.
SQL Server can't find my files
![](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(291.2, 76%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Penelope Vitoria
0
Reputation points
Hey.
Everytime I try to restore a database using SQL Server a message is showed:
"It is not possible to access the path or the file specified in the server. Verify if you have the necessary security privileges and if the path really exists". Well, the path really exists but I didn't find any content on internet that helps me to provide "that privileges" to SQL Server.
Right below the message in Portuguese. Anyone can help me?
SQL Server Other
{count} votes
-
Sedat SALMAN 14,180 Reputation points MVP2023-03-25T15:11:47.3166667+00:00 can you translate the error
are you trying to restore zip file if so please extract the backup file
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2023-03-26T12:50:57.39+00:00 Exactly what are you trying to do? The error message talks about a Zip file, and backup files from SQL Server typically does not end in .ZIP.
Also, using the UI in SSMS to restore databases can make things more complicated. I find it easier to just type the RESTORE command in a query window.
-
![](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' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,586 Reputation points2023-03-28T06:43:07.73+00:00 Hi @Penelope Vitoria ,
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.
Best regards,
Seeya
-
Seeya Xi-MSFT 16,586 Reputation points
2023-03-29T08:17:16.2033333+00:00 Hi @Penelope Vitoria ,
In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.
Best regards,
Seeya
Sign in to comment
2 answers
Sort by: Most helpful
-
![](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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator2023-03-26T15:34:49.05+00:00 -
Seeya Xi-MSFT 16,586 Reputation points
2023-03-27T02:51:00.1233333+00:00 Hi @Penelope Vitoria ,
I don't know your language. I have no way to translate screenshots with translation software. It looks like you used a zip extension for the restore. This is not possible, SQL Server has no way to unzip the zip file for you. You need to extract it manually or you can refer to this document for SQL Server backup compression.
Since the official documentation doesn't have screenshots, I've found another blog for you. Hope this is useful for you.
https://sqlbak.com/blog/how-to-configure-backup-compression
If I have misunderstood you, please feel free to let me know.
Best regards,
Seeya
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".