Reducing the database size when the database is full 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. When you upgrade from an embedded database with a size larger than 10 GB, and you are in the middle of the upgrade to Microsoft SQL Server Express, the upgrade process cannot continue.
If the Management Server Configuration Wizard detects that the database size is already too large, you may see the following messages:
The SQL Server Express database has reached its 10 GB limit. You must reconfigure the upgrade settings to import less data first. Then run the upgrade wizard again.
When the default database size is too large, pause the upgrade and perform the following steps:
Step 1: : Decrease the number of days that logs are collected
In the following file, reduce the number of days:
C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\conf.properties
This reduces the amount of data that migrates to the SQL Server Express database.
scm.sqlexpress.migration.clientserveractivity.daysis already set to 7 by default to keep the database size smaller.
Step 2: Restart the Management Server Upgrade Wizard
..\Symantec\Symantec Endpoint Protection Manager\bin\upgrade.bat
If you had started the
Database Backup and Restoredialog box before you made these changes, restart it by double-clicking
..\Symantec\Symantec Endpoint Protection Manager\bin\dbtools.bat