Follow

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 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'"

 

SQL Error

[Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.

 

Workarround

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 1 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.