Shrink Database

HOW TO SHRINK DATABASE

Here’s how to shrink the database file size:
DBCC SHRINKDATABASE (0, 10)

Results:

Some cases after doing the above, the file size does not shrink too. Do the following:
ALTER DATABASE otomax SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (otomax, 5)
GO
ALTER DATABASE otomax SET RECOVERY FULL

Results:

Then repeat the steps from the beginning using DBBC SHRINKDATABASE and then check the size of your database file.