Tuesday, August 07, 2012 11:02 AM
after disable TDE on my database and drop certificate and DMK , is it must to restart my SQL instance to create new tempdb files? ..
Tuesday, August 07, 2012 12:10 PM
Yes, If there are not any other databases in the instance with TDE enabled, this action will regenerate the TEMPDB database in an unencrypted format.
Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!
Tuesday, August 07, 2012 12:24 PM
but i have many other databases and restart will impact theri availability ...
so it's must to restart the instance ??
Tuesday, August 07, 2012 12:47 PM
When you enable TDE on a database, tempdb is also encrypted. If you are not using it anymore and no other databases are using TDE, your only options is to restart the instance to regenerate tempdb.
I hope it helps.
There are 10 type of people. Those who understand binary and those who do not.