-- SQL Express Instance
RESTORE DATABASE [TDEDatabase] FROM  DISK = N'c:\temp\TDEDatabase.bak' 
WITH  FILE = 1,  MOVE N'TDEDatabase' TO N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\TDEDatabase1.mdf',  
MOVE N'TDEDatabase_log' TO N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\TDEDatabase1_log.LDF',  NOUNLOAD,  STATS = 10
GO

/* Error
Msg 33111, Level 16, State 3, Line 1
Cannot find server certificate with thumbprint '0xE2AC82C187882EE5407D48C7A4BF97C6C2FBBD84'.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
*/

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'SecretP@ssw0rd'
GO
BACKUP MASTER KEY TO FILE = 'C:\temp\MSDE-MasterKey.pkf' 
    ENCRYPTION BY PASSWORD = 'SecretP@ssw0rd'

CREATE CERTIFICATE TDECertificate
    FROM FILE = 'C:\temp\TDECertificate.cer'
    WITH PRIVATE KEY (FILE = 'C:\temp\TDECertificate.pvk', 
    DECRYPTION BY PASSWORD = 'SecretP@ssw0rd');
GO 

RESTORE DATABASE [TDEDatabase] FROM  DISK = N'c:\temp\TDEDatabase.bak' 
WITH  FILE = 1,  MOVE N'TDEDatabase' TO N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\TDEDatabase1.mdf',  
MOVE N'TDEDatabase_log' TO N'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\TDEDatabase1_log.LDF',  NOUNLOAD,  STATS = 10
GO
/*

13 percent processed.
22 percent processed.
31 percent processed.
40 percent processed.
53 percent processed.
62 percent processed.
71 percent processed.
80 percent processed.
94 percent processed.
100 percent processed.
Processed 176 pages for database 'TDEDatabase', file 'TDEDatabase' on file 1.
Processed 3 pages for database 'TDEDatabase', file 'TDEDatabase_log' on file 1.
Msg 33117, Level 16, State 2, Line 1
Transparent Data Encryption is not available in the edition of this SQL Server instance. See books online for more details on feature support in different SQL Server editions.
Msg 3167, Level 16, State 1, Line 1
RESTORE could not start database 'TDEDatabase'.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 933, Level 21, State 1, Line 1
Database 'TDEDatabase' cannot be started because some of the database functionality is not available in the current edition of SQL Server.
*/