DBCC CLONEDATABASE exception 12605 : Failed to create snapshot database

190 views Asked by Nicolas Souquet At 21 September 2021 at 16:03

I'm executing the following instruction :

DBCC CLONEDATABASE(mydb_prod, mydb_clone)

And here is the exception I get :

Database cloning for 'mydb_prod' has started with target as 'mydb_clone'. Msg 12605, Level 16, State 1, Line 1 Failed to create snapshot database.

I looked into SQL Server logs, and only get :

Database cloning for 'sqllog_ivalua_prod' has started with target as 'sqllog_ivalua_clone'.

I've searched the Internet, with no answer. There is plenty of free disk space on the target volume. No user object is in the model database.

I looked into Extended Events to find out whether there are events related to cloning a database, or any DBCC command, but none related to cloning.

Do you have an idea ?

TechQA.