Database cloning – CLONEDATABASE
Database cloning is a new feature supported in SQL Server. Only SQL Server 2014 SP2 and SQL Server 2016 SP1 support cloning. The command syntax is very simple
|
1 2 3 |
DBCC CLONEDATABASE (source_database_name, target_database_name) |
For example the next command
|
1 2 3 |
DBCC CLONEDATABASE (AdventureWorks2014, AdventureWorks2014_Clone) |
will create database AdventureWorks2014_Clone with Continue reading Database cloning – CLONEDATABASE