Azure Sql db

Question

Hello Team,

I have 1 Azure SQL DB(15 Tables) of 1 TB.I need to clean the Azure SQL DB. Please advise me can i do the DBCC SHRINKDATABASE. So that it can reduce the size.

If no,Please advise me the correct suggestion to reduce the size of the DB.

Regards
Rohit

Answer 1

@Rohit Kulkarni Thank you for reaching out.

You can use SHRINKDATABASE if you have a high number of Truncate, Delete table operations or ETL operations on this database
Otherwise, it is usually not required to manually shrink a database. Some best practices are here

Please be aware that after shrinking the database, indexes may become fragmented and lose their performance optimization effectiveness.
You should use an index maintenance solution like SQL Server Index and Statistics Maintenance to rebuild and reorganize indexes after a shrink operation.

Do let us know if you have any further questions.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.