Forum Discussion
Bak file not visible when trying to restore database
Hi, Michelle.
The third screenshot is the most useful, where it appears you have pasted the full file path into the wrong input box.
You've pasted it up top in the file navigation bar, where it should be pasted at the bottom of that dialog window in the "File name" input box.
Also, double-check that the database service account really does have access to the file. We can see a user account named "MSSQLSERVER" features in your ACL but that doesn't mean it's the right account.
It'd be less troublesome if you just stored the backup file outside of your user profile, as that's never a great area to save such things in (for permissions administration reasons).
You'll have a much easier time if you store backups in a directory structure where the SQL database service account can "walk" the full structure.
Cheers,
Lain
Hi, Michelle.
The third screenshot is the most useful, where it appears you have pasted the full file path into the wrong input box.
You've pasted it up top in the file navigation bar, where it should be pasted at the bottom of that dialog window in the "File name" input box.
Also, double-check that the database service account really does have access to the file. We can see a user account named "MSSQLSERVER" features in your ACL but that doesn't mean it's the right account.
It'd be less troublesome if you just stored the backup file outside of your user profile, as that's never a great area to save such things in (for permissions administration reasons).
You'll have a much easier time if you store backups in a directory structure where the SQL database service account can "walk" the full structure.
Cheers,
Lain
- Thank you so much! I copied it to "Program Files" folder, finally found the file
