Good day all,
Well this problem first occurred for me when moving from SQL2008 to SQL2008R2. Now I have reinstalled my database machine again and am going from 2008R2 to 2008R2 - same version this time, but same problem.
I have restored my master key and certificate successfully, and the restore seems to complete according to the status output, but the query executes infinitely and the database even after server restart is inaccessible.
Here is the restore code and output:
View Complete Post