DBCC CLONEDATABASE can not Copy Encrypted Objects

There is a new command DBCC CLONEDATABASE from latest SQL Server 2014 SP2, SQL Server 2016 SP1 release. It’s designed to collect the database objects definition, index statistic and query store info without table data. It’s useful when support team need to investigate the performance issue like suboptimal execution plan remotely. Using DBCC CLONEDATABASE could keep…

0