How to disable auto shrink in SQL Server
Disable auto shrink in an SQL Server database.
-
Access the properties of the database.
- Right-click in the database.
- Select the option Properties.
-
Disable auto shrink.
- Select the page Options.
-
Disable auto shrink.
- Auto Shrink: Select False.