SQL Server 2005: Restoring the backup of a database that uses encryption

I have addressed this topic in previous threads and comments (here, here, and here, for example), both on this blog and on various forums, but it looks like when you need the answer, it can be hard to dig out. So I’m hoping that by placing these steps in a dedicated post, they will become easier to find. When…

12

SQL Server 2005: How to recover when the service master key (SMK) is not accessible

I wrote earlier today a reply on this topic on the public forums, but now that I checked, the reply appears to have got lost, although I still entertain the hope it may only have got delayed and will appear there in 24 hours. Anyway, this is the reason why I prefer to write longer…

8