SQL Server logshipping and TDE

[niall5098]

HI All,

i have encrypted a database but i now want to setup logshipping to a separate server.

restoring the database is fine however i have to use T-SQL to perform the restore as i need to open the master key in advance of the restore.

when i setup logshipping , it is successful but the apply logs job fails and i assume it is because i need to open the master key prior to restore step.

is there a way around this?

i read somewhere that if you setup logshipping before encrypting the database then that will work.

any ideas?

Thanks in advance,