Databases grow naturally, as you add and remove, or update rows. This is because botheth tables grow, and the log files which store information on what happened to the DB get larger as well.
Start with your logs:
Managing Transaction Logs – SQLServerCentral[
^]
Then consider rebuilding your indexes:
Reorganize and Rebuild Indexes - SQL Server | Microsoft Docs[
^]
And finally you can specify growth patterns:
SQL Server Database Growth and Autogrowth Settings - Simple Talk[
^]
But do these in that order - they will produce the "best effect" first, and cause more problems as you move down the list: setting a max size can casue some real problems later on if you aren't careful.
Submit an article or tip