SEPM Replication fails to partner - The SQL Server Express Database available space left is less than 512 MB

Products

• Endpoint Security Complete

Issue/Introduction

Partner Database is stating that "The SQL Server Express Database available space left is less than 512 MB."

Environment

Release : 14.3 RU5

Cause

The error message indicates that the database has reached its storage limit.
This is common with SQL Server Express as it has a maximum database size limit of 10 Gb.

SCM-SERVER-0.log

THREAD 40 SEVERE: The SQL Server Express database available space left is less than 512 MB. You may need to remove data from the database.
THREAD 40 SEVERE: Database free space below critical, Updating server health
THREAD 57 SEVERE: The SQL Server Express database available space left is less than 512 MB. You may need to remove data from the database.
THREAD 40 SEVERE: Stop ClientTransport.
THREAD 40 SEVERE: There is not enough database space, Stopping Client Transportion, stopping task to collect logs.
THREAD 40 SEVERE: Stop ClientTransport.

Resolution

- Decrease the number of days that logs are collected
- Restart the Management Server Upgrade Wizard
- Enable FILESTREAM for the Microsoft SQL Server database (if it is not enabled)
- Maintain the Database

Before an upgrade to Microsoft SQL Server Express
https://techdocs.broadcom.com/us/en/symantec-security-software/endpoint-security-and-management/endpoint-protection/all/upgrading-to-a-new-release-v14510472-d27e6/Increasing-database-space-when-the-database-is-full.html

Enabling FILESTREAM for the Microsoft SQL Server database
https://techdocs.broadcom.com/us/en/symantec-security-software/endpoint-security-and-management/endpoint-protection/all/upgrading-to-a-new-release-v14510472-d27e6/Enabling-FILESTREAM-in-SQL-Server.html

Maintaining the database
https://techdocs.broadcom.com/us/en/symantec-security-software/endpoint-security-and-management/endpoint-protection/all/Managing-management-servers-sites-and-databases/maintaining-the-database-v54167871-d15e9.html