I recently start in new job here decide to move all database from different servers to a new db server. The previously person was working here doesn't documented any password was used for the master keys in the multiples db servers.
It is possible to recover, restore, change or do something with the master keys?
When I restore a database using backup method or attach I get the following error:
Msg 15581, Level 16, State 3, Line 4
Please create a master key in the database or open the master key in the session before performing this operation.
I really appreciate any help, suggestion to complete this task as soon as possible.
View Complete Post