Restore database from .bak PW protected

[alexrap2010]

I'm trying to restore a database from a .bak password protected, but i failed all the time.

I used this query


and i get this error


But i think a query like this will fix the issue.



If there's anyone PRO in SQL and wants to help me, i appreciate.

Thank you,

[Lelouch9]

why you use query to restore database
if you have .bak database pw restore it by the normal steps
1-right clieck on database example [SRO_VT_SHARD] then chose tasks
2-then chose restore > database
3-then chose your db .bak file
4-check options and click on overwrite the existing database
5-then check ok it will done

if it not working pm me on m skype

[alexrap2010]

Nah, the only solution was restoring by query, i tried the normal way but useless.

This query was the solution and had to change the Files Security Settings where the .bak's are located



#request for close