{"id":9081,"date":"2026-10-23T21:09:57","date_gmt":"2026-10-23T18:09:57","guid":{"rendered":"https:\/\/support.withsecure.com\/support-articles\/policy-managers-database-is-very-large-in-size-how-can-the-size-be-reduced\/"},"modified":"2026-10-23T21:09:57","modified_gmt":"2026-10-23T18:09:57","slug":"policy-managers-database-is-very-large-in-size-how-can-the-size-be-reduced","status":"publish","type":"support_article","link":"https:\/\/support.withsecure.com\/en\/support-articles\/policy-managers-database-is-very-large-in-size-how-can-the-size-be-reduced\/","title":{"rendered":"Policy Manager's database is very large in size. How can the size be reduced?"},"content":{"rendered":"<h3>Issue:<\/h3>\n<p>Policy Manager&#39;s H2DB has grown very large in size. how can the size be reduced?<\/p>\n<h3>Resolution:<\/h3>\n<p>In most cases the growth of the H2DB is due to old alerts and Scanning reports. This can be resolved 2 ways either from the user interface or using the Database recovery tool.<\/p>\n<p><b>Interface:<\/b><\/p>\n<p>To reduce the size open the Policy Manager Console:<\/p>\n<ol>\n<li>Log in to the Policy Manager Console<\/li>\n<li>Select <strong>Root <\/strong>from the domain tree<\/li>\n<li>Go to the <strong>Alerts <\/strong>tab<\/li>\n<li>Click <strong>Select all <\/strong>from the right side of the table and then click <strong>Delete<\/strong><\/li>\n<li>Go to the <strong>Scanning reports <\/strong>tab<\/li>\n<li>Click <strong>Select all <\/strong>from the right side of the table and then click <strong>Delete<\/strong><\/li>\n<li>Restart the Policy Manager Server services by running: <strong>net stop wspms<\/strong> and <strong>net start wspms<\/strong>. Restarting the services will force the database to recompact itself immediately.<\/li>\n<\/ol>\n<p><b>Database Recovery Tool:<\/b><\/p>\n<p id=\"product-short-description\">Policy Manager includes a database maintenance tool that optimizes and checks the integrity of your database.<\/p>\n<div id=\"product-description\">\n<div><strong>Note<\/strong>: Before running the maintenance tool, check that there is enough free disk space available on the computer where Policy Manager is installed. The disk space requirements for the maintenance tool depend on the size of your database, but as a guideline you should have at least twice as much free space as the size of your database.<\/div>\n<p>Database maintenance is automatically started as part of any Policy Manager upgrade or re-installation to ensure that the database structure is compatible with the latest version.<\/p>\n<p>The maintenance tool creates a backup of your database, after which it verifies the database integrity and then applies the updated schema to the contents of the database. It also cleans up any invalid data to optimize the size and performance of the database.<\/p>\n<p>To run the database maintenance tool manually:<\/p>\n<ol style=\"list-style-type: none;\">\n<li>1. Stop the Policy Manager service.<\/li>\n<li>2. Start the maintenance tool.\n<ul style=\"list-style-type: square;\">\n<li>On Windows, run C:\\Program Files\\WithSecure\\Policy Manager Server\\bin\\fspms-db-maintenance-tool.exe. When the maintenance tool opens, click Start maintenance.<\/li>\n<li>On Linux, run the \/opt\/f-secure\/fspms\/bin\/fspms-db-maintenance-tool script.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>The progress and details of the maintenance steps are shown.<\/p>\n<p>\u00a0<\/p>\n<div><strong>Note<\/strong>: The maintenance tool may skip some of the maintenance steps, for example if the database schema is already up to date. However, the overall maintenance can still be successful even with skipped steps.<\/div>\n<ol style=\"list-style-type: none;\">\n<li>3. On Windows, after the maintenance steps have run, click Close.<\/li>\n<li>4. Restart the Policy Manager Server service<\/li>\n<\/ol>\n<p>If the maintenance is not successful, no changes are applied to the database and Policy Manager Server is not started.\u00a0<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Policy Manager's H2DB has grown very large in size. how can the size be reduced?<\/p>\n","protected":false},"template":"","support_article_product":[106],"class_list":["post-9081","support_article","type-support_article","status-publish","hentry"],"acf":{"source_foreign_id":"000009107","source_version":1,"source_system":"salesforce","source_date_updated":"2026-10-23 18:09:57","import_hash":"8c845267bfa7064af356c238b25772a46147f4f5","vanilla_article_id":33471,"vanilla_url":"https:\/\/community.withsecure.com\/en\/kb\/articles\/33471-policy-managers-database-is-very-large-in-size-how-can-the-size-be-reduced","vanilla_kb_id":30,"vanilla_category_id":103,"machine_translated":false,"reactions_helpful_yes":0,"reactions_helpful_no":0},"_links":{"self":[{"href":"https:\/\/support.withsecure.com\/en\/wp-json\/wp\/v2\/support_article\/9081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.withsecure.com\/en\/wp-json\/wp\/v2\/support_article"}],"about":[{"href":"https:\/\/support.withsecure.com\/en\/wp-json\/wp\/v2\/types\/support_article"}],"wp:attachment":[{"href":"https:\/\/support.withsecure.com\/en\/wp-json\/wp\/v2\/media?parent=9081"}],"wp:term":[{"taxonomy":"support_article_product","embeddable":true,"href":"https:\/\/support.withsecure.com\/en\/wp-json\/wp\/v2\/support_article_product?post=9081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}