SQL database size growing and SQL backups not working.

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

Capture.JPG

Affected  versions

7,8,+

Was this article helpful?
0 out of 2 found this helpful
Have more questions? Contact us