DBCC CLONEDATABASE to generate a schema and statistics only copy of a user database in SQL Server 2014 SP2

Microsoft released SQL Server 2014 Service Pack 2, which contains a new command: DBCC CLONEDATABASE. This new command creates a clone of a database’s schema and statistics (not the data of tables). Since it has the statistics, it is useful for troubleshooting, investigating, and diagnosing performance issues.

This will eliminate your production database to diagnose query performance tuning on problematic procs or TSQL.


in the following example, I have cloned adventureworks 2014.

Syntax: DBCC CLONEDATABASE (source_database_name, target_database_name)

dbcc clonedatabase([AdventureWorks2014],[AdventureWorks2014_Clone])

for more information please read Microsoft KB article.



dbcc clone

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s