Knowledge Base

SpaceObServer



Question / Problem

My database consumes a lot of disk space. What can I do to reduce the occupied disk space?

Answer / Solution

There are ways to reducethe occupied disk space as well for MS Access as for MS SQL Server:)" to reduce the occupied diskspace. SpaceObServer will perform this action at regular intervals.You may adjust the maximumsize of your "transaction protocol" of your MS SQL Server database by using theintegrated Enterprise Manager. Please do a right-click on the database andchoose the "Transaction protocol" tabfrom the "Properties" dialog.>/pPlease note: If you restrict the maximum file sizeof your database, you should not use the complete recovery model (Options/Recovery model), because youwon’t be able to make changes in the tables, if the maximum file size isreached.