Reducing the database size to less than 10 GB before an upgrade to Microsoft SQL Server Express

The default Microsoft SQL Server Express database has a size limit of 10 GB for data files and log data. Data files include items such as installation packages, virus definitions, policies, alerts, and learned applications. When you upgrade from the embedded database (14.3 MP1 and earlier) with a size larger than 10 GB, the upgrade process to SQL Server Express cannot continue. If the Management Server Configuration Wizard detects that the database size is too large, you may see the following message:
The backup exceeds the allowed SQL Server Express 10 GB limit. You must first reconfigure the management server to import less data. Then run the restore again.
The estimated data in the embedded database exceeds the Microsoft SQL Server Express limit of 10 GB. To continue the upgrade, the wizard must first reduce the amount of data to less than 10 GB.
You must first decrease the space in the existing embedded database, using one of the following tasks:
  • Click
    so that the Management Server Configuration Wizard decreases the database size at the beginning of the upgrade process.
  • Cancel the Management Server Configuration Wizard, reduce the database size yourself, and restart the wizard using the following steps.
To reduce the amount of available database size manually: