I have removed Transparent Data Encryption (TDE) from my server, dropped the key and switched the databases to Simple, shrunk the log and then back to Full.
The LOG backups are now smaller as well as the full backups but the main mdf files are still the same size after removing TDE.
Is this normal? Is there a way to get these back to what they were before TDE?
I know the MDF files will stay the same size until you shrink them but the space available inside I would have expected to increase significantly but it didn't. TDE seemed to double the size of them.