nService deletes old logs and emails in order to keep the database size small.
nService runs two SQL statements nightly to help you control your database's size. 
DELETE ns4_event_log WHERE el_created_on < '{0}' 

DELETE ns4_email WHERE (em_folder = 3 OR em_folder = 5 OR em_folder = 7) AND em_created_on < '{0}'
If there are too many records to delete, you may run into SQL Execution time out error. The administrators of nSerivce would receive an email. To fix this problem, you can try running these two SQL statements directly on SQL Server Management Studio. Suppose today is 04/07/2019, try these two SQL statements to delete logs and emails older than 7 days.
DELETE ns4_event_log WHERE el_created_on < '20190401' 

DELETE ns4_email
WHERE (em_folder = 3 OR em_folder = 5 OR em_folder = 7) AND em_created_on < '20190401'
Always backup your nService database before running any SQL statement directly on your database using SQL Server Management Studio.
Article #1513
Updated On: 4/16/2019 Index
Was this article helpful? Yes | No