"DBCC SHRINKFILE for data files is not supported in a Hyperscale database" error trying to shrink db

Question

"DBCC SHRINKFILE for data files is not supported in a Hyperscale database" error trying to shrink db

Nathan Allan 0

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.

Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator

2025-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:

https://techcommunity.microsoft.com/blog/azuresqlblog/shrink-for-azure-sql-database-hyperscale-is-now-generally-available/4371490
Sai Raghunadh M 4,300 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.
Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator

2025-06-16T16:29:42.2366667+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.

1 answer

Your answer

Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator

2025-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:

https://techcommunity.microsoft.com/blog/azuresqlblog/shrink-for-azure-sql-database-hyperscale-is-now-generally-available/4371490
Sai Raghunadh M 4,300 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.
Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator

2025-06-16T16:29:42.2366667+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.

Answer 1

PratikLad 1,665 Microsoft External Staff Moderator

Hi @ Nathan Allan

Shrink is currently in preview mode and has the following limitations:

Shrink is not allowed on unencrypted databases. Any such attempt raises the following error:

_Msg 49532, Level 16, State 1, Line 1

_DBCC SHRINKFILE for data files is not supported in a Hyperscale database when the database is not encrypted. Enable transparent data encryption and try again.

To find the encryption state of the database, execute the following query:


SELECT db_name(database_id) AS 'database_name'

   ,encryption_state_desc

FROM sys.dm_database_encryption_keys

WHERE database_id = db_id()

If encryption state is other than ENCRYPTED then shrink will not start.

You can enable encryption on the database using this : https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?view=azuresql&tabs=azure-portal

If this answers your query, do click Accept Answer and Upvote for was this answer helpful.

PratikLad 1,665 Reputation points Microsoft External Staff Moderator

2025-06-17T15:26:24+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.
PratikLad 1,665 Reputation points Microsoft External Staff Moderator

2025-06-18T14:09:45.54+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.
Nathan Allan 0 Reputation points

2025-06-20T20:56:30.6033333+00:00

Hi, thanks you for your response. As stated in my original message, the database IS encrypted. encryption_state_desc is ENCRYPTED

Thanks,

-Nate
Balmukund 176 Reputation points Microsoft Employee

2025-06-23T05:40:11.1466667+00:00
@Nathan Allan the query shows database_id = 2. Can you please run the query on the database where you are getting error?

Share via

"DBCC SHRINKFILE for data files is not supported in a Hyperscale database" error trying to shrink db

1 answer

Your answer