DBCC Clonedatabase -cant make it work

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

avatar image By gk4tech 1 asked Feb 01 at 11:55 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

1 answer: sort voted first

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.)

2016sp1.png (29.9 kB)
avatar image By Aaron Bertrand ♦ 1.7k answered Feb 03 at 04:45 PM
more ▼
(comments are locked)
10|10000 characters needed characters left
Your answer
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question



asked: Feb 01 at 11:55 PM

Seen: 563 times

Last Updated: Feb 03 at 04:46 PM