DBCC Clonedatabase -cant make it work

gk4tech 2017-02-01 23:55:58

Hi on 2016 developer edition
Cant get DBCC to work- when i copy exact command from manual, just change the names of the dbs

DBCC CLONEDATABASE (productdb, productdb_Clone);

i get this result-

Msg 2526, Level 16, State 3, Line 4
Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.

And productdb exists, productdb does not exist, and i tried it with quotes and the (N'productdb'…. style too

Aaron Bertrand 2017-02-03 16:45:15
You are on SQL Server 2016 RTM. This feature was added in 2016 SP1, so your build must be at least 13.0.4001. From the documentation:

alt text

(In the future, please post general SQL Server questions over at dba.se – this site is dedicated to execution plan issues.)