The MS SQL has generated an error while restoring the database. How to recover mssql database ?
When I go to restore the developed database in MS SQL from the backup of production database, it gets encrypted. The errors get generated by trying to open the symmetric key once the database is restored. The error code is:
OPEN SYMMETRIC KEY DECRYPTION BY CERTIFICATE
The error generated is:
Msg 15466, Level 16, State 1, Line 1
An error occurred during decryption.
I want a solution of how to recover mssql database and get free from this error. Any idea?
The error generated is:
Msg 15466, Level 16, State 1, Line 1
An error occurred during decryption.
I want a solution of how to recover mssql database and get free from this error. Any idea?


