This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(278.4, 23%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
I am setting up a test environment on my PC. I installed SQL Server 2019 Express (Microsoft SQL Server 2019 (RTM-CU18) (KB5017593) - 15.0.4261.1 (X64) Sep 12 2022 15:07:06 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 19045: ) ). I want to restore a DB for testing. I go through the steps and navigate to where the .bak file is but SQL Server does not see the .bak file! I get this:
There is 100%, absolutely a .bak file in this folder. What is going on and how do I correct?
![](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)
Hi Dom •
You can try restoring the database using T-SQL Command
Here is a command.
Restore Database <Database Name>
from disk = 'C:\Domenick\<filename.bak'
with Recovery
I get this error. I am the only user on this machine. I am the admin with full control on C:. UAC is disabled. What is happening?
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:\Domenick\galactic.bak'. Operating system error 5(Access is denied.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
@RahulRandive Sorry - I don't know how to mark your "comment" as an "answer" - but it is!
I've converted Rahul's comment to an Answer, so that you can accept it.
Thanks for sharing error details. It's a permission/access issue to the folder.
Please follow below thread and grant appropriate permissions
https://stackoverflow.com/questions/3960257/cannot-open-backup-device-operating-system-error-5
yep - that did it. Guess I thought it was using my user that I log into SQL with - not NT Service\MSSQLSERVER. Thank you!
Hi Dom •
Great! Thanks for your comments an update.
Glad to know it worked. Please click Accept Answer and Mark Helpful for the same. This would be helpful for others community members to find it easily.
Glad to see that your problem has been resolved! Please remember to accept the answer if helped. Your action would be helpful to other users who encounter the same issue and read this thread.