Yes, I restored the backup of original certificate and when I tried to read the data it gives Null values.

Hello,

Thanks for your response. I tried restoring the certificate and I was still not able to read the data, not sure if some thing is wrong in our environment.

-Shyam.

Hello Perry,

Thanks for your reply. However as I mentioned in my post, Dev server has certificate already and other databases on Dev are encrypted with TDE.

so I can't restore...

Thanks for your reply, however it take many hours to do a Import/Export.

The table size is 20GB.

I tried to take the filegroup backup and I am able to...

Thanks for your inputs

Hi Gila,

Thanks for your responce, we have only one drive and that drive is on 1024 sector, the database size is 600 GB. Also this is not only with ldf...