SQL Server Compressed Database footprint

1. Delete unnecessary data from the database library
2. Right-click on the database, task, shrink, file, select reorganize the page before unused space on the shrink operation, minimize the last behavior of the file to XXM, fill in the value in the preceding input box, and click OK
3. Detach the database and select Delete connection, next delete the database's. log file, then attach the database, in the database in the detailed list, will be prompted to find the log, next select the line, click the following delete, finally only the MDF file, and then click OK
4. This allows the database to be compressed to a minimum.

SQL Server Compressed Database footprint