Preparing an encrypted TDE enabled database for restore on a Standard Edition SQL Server
Friday, May 7th, 2010
I recently had the challenge of restoring an encrypted database on to a standard edition server to enable further development on the database code. It took some work, but to save you some time, I’ve listed the steps (and the T-SQL) in this article that you need to take in order to accomplish this.