SQL database size growing and SQL backups not working.
Symptom
The database is rapidly increasing in size per day. After some investigations, you’ve discovered that the event logs aren’t being purged out of the database and in some cases, the backup logs show this error.
Kaseya archive log error
"Incorrect syntax near 'xp_cmdshell'"
SQL Error
[Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.
Workaround
Increase the rights of the account used to perform the SQL archiving
Affected versions
7,8,+