• To eliminate the TDE is causing problems we have removed it

    USE [master] ;

    GO

    -- remove tde

    ALTER DATABASE [VoruhusGagna] SET ENCRYPTION OFF ;

    GO

    -- monitor the progress

    SELECT [percent_complete], *

    FROM [sys].[dm_database_encryption_keys] ;

    USE [VoruhusGagna]

    GO

    DROP DATABASE ENCRYPTION KEY ;

    GO

    -- verify encryption removed

    SELECT [name], is_encrypted, *

    FROM sys.databases

    WHERE [name] = 'VoruhusGagna' ;

    GO

    We are baking a brand new full backup to try out on the 2016 server...