Return
-
Title
Troubleshooting excess backup database or database too large after attempting to upgrade your KACE SMA appliance -
Description
Excess Backup Database Files are present on your appliance and they are outside the scope of your current backup settings. Example: Appliance is set to have 5 daily and 2 monthly backups saved for a total of 7, but list of backup files contains numerous others or you have received an error Database to large while upgrading. -
Cause
This may be the result of a "bloated" database table. Please contact KACE Technical Support. -
Resolution
Steps to take before contacting KACE Technical Support.
- Obtain a CURRENT Backup and SAVE the necessary backups (including the most recent one) OFF OF THE APPLIANCE and onto a Network/External location (See additional notes).
- Ensure that SSH is enabled. This will allow KACE to access as needed in the event that the appliance becomes unresponsive.
If you are enabling this now, it will require a Restart of the Appliance; so obtain your backups and test them BEFORE you perform a Restart. - Obtain this patch from KACE Technical Support and install it by going to Settings | Server Maintenance. Click Edit Mode | Manually Update K1000. Browse to where you saved kbox_patch_sizereport.kbin. Click Update K1000. This will run the size report. Go to \\k1000\client\sizereport.txt for the output.
*NOTE* When you contact KACE Technical Support, please provide the following:
- What version of the Appliance are you currently on?
- Are your backups saved off of the Appliance and tested successfully? (this will let us know it is okay to work on the database)
- Download the troubleshooting logs to send to KACE if needed:. (K1000 Settings | Support | Troubleshooting Tools | K1000 Troubleshooting Logs)
- Provide the size report as listed in Step three.
Additional Notes
How to manually run the backup script and retrieve the files from the K1000: https://support.quest.com/k1000-systems-management-appliance/kb/111735
How to enable SSH on the KACE appliance:https://support.quest.com/k1000-systems-management-appliance/kb/111182
Contacting KACE Support: https://support.quest.com/kb/111230
-
Additional Information
File Management Note: Managing Secure Backups of the K1000: Enable ‘Secure Backup Files’ to prevent backup files from being downloaded via HTTP/S without authentication.