Bak file not visible when trying to restore database

[MichelleCuna]

I am having an issue restoring the bak file. I already added SQL in security but still not reflecting

I couldn't find the bak file no matter where I search

I already tried pasting the file path

[#2 · Accepted solution]

@MichelleCuna 

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

[#3]

@MichelleCuna , you located the backup file in your user profile, where only your account do have access permissions for, but may not the SQL Server service account.

Move the BAK file to the BACKUP folder of your SQL Server installation, that's what's good for.

[#4]

Thank you so much! I copied it to "Program Files" folder, finally found the file