How to disable auto shrink in SQL Server

Disable auto shrink in an SQL Server database.

  1. Access the properties of the database.
    1. Right-click in the database.
    2. Select the option Properties.
  2. Disable auto shrink.
    1. Select the page Options.
    2. Disable auto shrink.
      • Auto Shrink: Select False.