DBCC clondatabase in SQL Server

dbtut

5 years ago

What is dbcc clondatabase in SQL Server

DBCC ClonDatabase announced with SQL Server 2014 SP2. We are able to create a copy of the database without data to analyze query performance issues with the DBCC Clondatabase command.

Although there is no data in the clone database, it produces the same execution plan as the production database. This helps us to analyze the problem in the production database without data.

To run this command, you must use the most current version of the version you are using. Because there are bugs related to this command in SQL Server 2014 SP2, and early versions of SQL Server 2016.

How To Use DBCC Clondatabase

You can use it as follows:

DBCC clonedatabase('AdventureWorks2014', 'my_first_clondatabase');

1	DBCC clonedatabase('AdventureWorks2014', 'my_first_clondatabase');