The Clone Limits

Question

Post reply

The Clone Limits

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
August 18, 2016 at 11:13 pm

#74545

Comments posted to this topic are about the item The Clone Limits
August 19, 2016 at 1:37 am

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

HappyGeek SSCoach Points: 18729 More actions · Answer 1

HappyGeek

SSCoach

Points: 18729

August 18, 2016 at 11:13 pm

#1896288

Good question thanks Steve

...

Mike Hays SSCommitted Points: 1871 More actions · Answer 2

Good Question, did not know that this command existed...

sknox SSChampion Points: 12388 More actions · Answer 3

Mike Hays (8/19/2016)
Good Question, did not know that this command existed...

It's new in 2014SP2 -- and not in 2016 (yet).

George Vobr SSChampion Points: 10008 More actions · Answer 4

Thanks Steve for this question, interesting is there a more things, such as

DBCC CLONEDATABASE is only for version SQL Server 2014 SP2.

In SQL Server 2016 is not yet, or there may be used the Copy Database Wizard,

but still some DBAs wish to have DBCC CLONEBATABASE also in SQL 2016,

see e.g. http://jasonbrimhall.info/2016/07/13/sql-server-desired-enhancements/

Perhaps these voices will be heard by Microsoft.

Happy weekend to all. 🙂

Revenant SSC-Forever Points: 42467 More actions · Answer 5

sknox (8/19/2016)
Mike Hays (8/19/2016)
Good Question, did not know that this command existed...
It's new in 2014SP2 -- and not in 2016 (yet).

At least it is documented... 😉

Thanks, Steve!

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

D'oh, clicked on the wrong option. Thanks for the question 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP