How to resolve .bak files does not shown in the folder while restore in SQL Server

How to resolve .bak files does not shown in the folder while restore in SQL Server

you can see now we are going to restore standard edition 2012 from express edition 2012

Source

Express edition 2012

Destination:

SQL 2012 Standard edition 

now we are going to select .bak files from SQL 2012 Express edition

but it did not shown up as see below

but actually bak files existing on specified location

when we go to properties of folder it showed express edition service account which SQL Server running

it causes it did not show while choose file from SQL Standard edition

solution

we should need to give all permission on Restoring server Service account of which SQL server running our cases SQL Standard edition service account

Now we choose standard edition service account and give all permission on backup folder

now give all permission of standard edition service account

Now it shown bak files as see below

so restore database activity is done