SQL database size growing and SQL backups not working.
The database is rapidly increasing in size per day. After some investigations you’ve discovered that the evenlogs 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'"
[Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.
Increase the rights of the account used to perform the SQL archiving