0

I have a local SQL installed on drive C: and the data file of those system databases are stored on a network drive path, in this case it is AWS FSx.

When I attempt to restore a user database, I cannot browse anywhere. As a test I made sure I gave the user account which runs SQL service a full access to C:\temp but I keep getting this error.

SQL error log and window error log shows me nothing... any idea guys?

enter image description here

When I attempt to run it using SQL code, it works.

enter image description here

Improve this question
4
  • 1
    Instead of navigating the path, have you tried pasting the complete path at once? SQL Server doesn't have permission on the root of drive C: so you might have trouble if trying no navigate to C: before going to the next folder.
    – Ronaldo
    Jun 17 at 15:56
  • I tried to give that but no dice...the weird thing is when I attempt to run it via code, it works.
    – Fylix
    Jun 17 at 16:19
  • There is no built-in navigation in the "locate backup file" window. You must provide the full path, including the file itself, along with its extension (e.g., C:\Backupfolder\Backup.bak)
    – Mike Petri
    Jun 17 at 18:03
  • Hi Mike, that's not it I think. I have another environment where upon entering C: it let me browse the directory like a normal structure to find the .bak file.
    – Fylix
    Jun 17 at 18:48

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.