Shrink data file in databases on Azure SQL Managed Instance

mo boy 396

Dear Experts,

I came across this link which describes the process for performing a shrink operation on an Azure SQL DB. However, the same link says this does not apply to Azure SQL Managed Instance.

Could you please advise the recommended link for Azure SQL Managed Instance or please let me know why that link does not apply to Azure SQL Managed Instance?

Accepted answer

Bjoern Peters 8,871 Reputation points

2023-03-27T11:05:41.1066667+00:00
Hi mo boy,

I hope my answer is helpful to you,

Your

Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

Why not use the official "DBCC SHRINKFILE"?

https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?view=sql-server-ver16

It also supports Azure SQL Managed Instance.

USE UserDB; GO DBCC SHRINKFILE (DataFile1, 7); GO

I hope my answer is helpful to you,

Your

Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!
Please sign in to rate this answer.
GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee

2023-03-27T14:02:39.9566667+00:00

@mo boy Thank you for accepting the answer and for your feedback. We found out that your recent engagement on this question was rated low. Would you be kind to re-evaluate your feedback? if you are still looking for any additional questions please let us know.

Regrads

Geetha

SergioMSSQLdba-6621 0 Reputation points

2024-02-29T11:27:57.8+00:00

Using DBCC ShrinkFile didn't work for me, most likely due dbs are forced to be synchronize. At least for me I cannot find the proper way to make it work as even on GP service tier is still synchronize.
Does someone been able to do successfully dbcc shrinkfile on data on Azure arc enable SQL MI?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

Sedat SALMAN 13,740 Reputation points

2023-03-27T07:57:11.63+00:00

you can use Azure SQL Server instead

https://learn.microsoft.com/en-us/azure/azure-sql/database/file-space-manage?view=azuresql

Azure SQL Managed Instance
Please sign in to rate this answer.
mo boy 396 Reputation points

2023-03-27T08:12:40.41+00:00

This is the same link I have posted. It clearly states "This article does not apply to Azure SQL Managed Instance."

Sedat SALMAN 13,740 Reputation points

2023-03-27T08:19:50.7666667+00:00

yes Managed Instances are automatically managed you can not apply dbcc commands like shrinkdatase

mo boy 396 Reputation points

2023-03-27T08:36:56.6933333+00:00

Please don't provide wrong information if you are not sure. You can refer this link which describes DBCC shrinkdatabase option for all SQL databases including Azure SQL Managed instance. My question is around why the original link in the root question I posed does not apply to SQL managed instance.

Bjoern Peters 8,871 Reputation points

2023-03-27T11:02:53.97+00:00

Hi mo boy,

the link in the first post is about "SHRINKING FILES" and your link is about "SHRINKING DATABASE"
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Shrink data file in databases on Azure SQL Managed Instance

1 additional answer

Your answer