Azure SQL Database
An Azure relational database service.
6,307 questions
"DBCC SHRINKFILE for data files is not supported in a Hyperscale database" error trying to shrink db
![](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(256, 59%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nathan Allan
0
Reputation points
I get the following when attempting to use either SHRINKFILE or SHRINKDATABASE:
"DBCC SHRINKFILE for data files is not supported in a Hyperscale database when the database is not encrypted or protector change is in progress. Enable transparent data encryption or wait for protector change to complete and try again. Refer sys.dm_database_encryption_keys for more details."
When I selected from sys.dm_database_encryption_keys I get this:
database_id,encryption_state,create_date,regenerate_date,modify_date,set_date,opened_date,key_algorithm,key_length,encryptor_thumbprint,encryptor_type,percent_complete,encryption_state_desc,encryption_scan_state,encryption_scan_state_desc,encryption_scan_modify_date
2,3,2025-06-11 04:31:38.520,2025-06-11 04:31:38.520,2025-06-11 04:31:38.520,1900-01-01 00:00:00.000,2025-06-11 04:31:38.520,AES,256,0x,ASYMMETRIC KEY,0,ENCRYPTED,4,COMPLETE,2025-06-11 04:31:53.290
...which seems to indicate that the database IS encrypted.
Azure SQL Database
{count} votes
-
![](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(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M 4,120 Reputation points Microsoft External Staff Moderator2025-06-13T19:06:36.2966667+00:00 Hi @ Nathan Allan
Shrink for Azure SQL Database Hyperscale is now generally available.
Could you please refer the below blog that might help you:
-
Sai Raghunadh M 4,120 Reputation points Microsoft External Staff Moderator
2025-06-16T08:26:35.8166667+00:00 Hi @ Nathan Allan
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer