Online Documentation for SQL Manager for SQL server

Reduce database size

Database size reducing can be done by means of the Shrink Database Wizard. It allows reducing the size of data files and log files in the specified database. This operation is used to reduce any file within the database to remove unused pages. Both data and transaction log files can be reduced.

Note: You can shrink a database only if there are no active connections to this database and it is now involved in the replication.