Summary: This article provides some simple DB scripts to help IT Administrators with maintenance of the Kapa database on SQL Server. Please keep in mind that maintenance of the SQL server rests entirely upon your IT Department, and any advice contained herein is only provided for assistance of the IT Personnel, entirely on a goodwill basis. Support Issues for SQL Server should not be addressed to Helintec.
Attached Files:
FindDBSize.hsql This script will return the size in MBs for all databases residing on your server. Use this to test if you are approaching a possible size limit of your SQL server. For example, MSDE 2000 has a limit of 2GB.
ShrinkDB.hsql This script will instruct SQL Server to shrink the database, reusing any unused space. This can be particularly of help when the log file has grown too large. It could also help you temporarily avoiding crossing the size limit of your SQL server. However, in case you are near the limit, you are strongly encouraged to migrate to another SQL Server solution. Use this script as a temporary fix if you are getting errors like "'PRIMARY' filegroup is full". You can also reduce the number of Export entries retained in the DB, through the KapaMPI Admin utility.
RebuildIndexes.hsql This script will instruct SQL Server to rebuild all table indexes. Use this if you feel the program is unresponsive without a clear reason.
Disclaimer: The information on this article are provided as-is and are meant for experienced technical users only. If you do not feel at ease with any of the concepts of this article, please contact Helintec.