First, open the management tool of SQL SERVER and find the database to be operated, as shown in the following figure. Right-click and select Properties.

Then check the available space in the pop-up database attribute information interface. Generally, whether the database needs to be shrunk is judged according to the size of available space, as shown in the following figure.

Then we select the "Options" page in the database property page, as shown in the following figure, which contains the option settings for automatic shrinkage.

Find the automatic column information on the right side of the options page, as shown in the figure below, and set the automatic shrinkage option to TRUE. Once automatic shrinkage is set to true, the database will automatically monitor the free space size of data shrinkage.

In addition, manual shrinkage can be set in the database, as shown in the following figure. First, select the shrink database option.

In the pop-up database shrinkage interface, we will set the shrinkage ratio, which you can set according to your actual needs.

In addition, you can choose the option of shrinking database files, as shown in the following figure. You can select the corresponding shrinkage type. What I chose here is the option of releasing unused space. You can choose according to your own situation.