SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
How to clone database in SQL 2022?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 99%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOC%3C/text%3E%3C/svg%3E)
Oleg Cherkasenko
0
Reputation points
My customer has SQL 2022 (16.0.1000.6) and a production database.
To investigate performance of the database I need the db backup.
But customer cannot provide it because of some tables contain sensitive data.
I have tried to clone the db because it has Query Store data and it may be enough for now.
DBCC CLONEDATABASE: I am trying to clone database to get the clone for analysis. But received the error 2601, 14, Status 1 Cannot insert duplicate key row in object 'sys.sysrowsets' with unique index 'clust'. The duplicate key value is (72057594045530112).
What is the reason? How to fix it and create the database clone?
SQL Server Database Engine
-
Oleg Cherkasenko 0 Reputation points
2025-04-10T14:59:45.72+00:00 Do I have a chance to read any comments from Microsoft?
Sign in to comment
Sign in to answer