{"id":3264,"date":"2018-05-01T01:28:38","date_gmt":"2018-05-01T01:28:38","guid":{"rendered":"http:\/\/pariswells.com\/blog\/?p=3264"},"modified":"2022-12-02T00:38:06","modified_gmt":"2022-12-02T00:38:06","slug":"vmware-vcenter-vim_vcdb-database-primary-filegroup-is-full","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/random\/vmware-vcenter-vim_vcdb-database-primary-filegroup-is-full","title":{"rendered":"VMware Vcenter &#8211; VIM_VCDB database &#8216;PRIMARY&#8217; filegroup is full"},"content":{"rendered":"\n<p>Recently a customer had filled up their free SQL Express Database with Events and Tasks from Vmware. The Hosts has both gone to Disconnected with error<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">cannot synchronize host cannot contact the specified host<\/h3>\n\n\n\n<p>and when trying to re-add the error would be displayed<\/p>\n\n\n\n<p><strong>VIM_VCDB database \u2018PRIMARY\u2019 filegroup is full<\/strong><\/p>\n\n\n\n<p><em><strong>failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.<\/strong><\/em><\/p>\n\n\n\n<p>SQL Express has a 4GB database limit, we need to clear out the old logs and don\u2019t want to install and download SQL management studio so we need to run the below in command prompt with the same user that installed the DB or has write permissions to it!<\/p>\n\n\n<div class=\"wp-block-wab-pastacode\">\n\t<div class=\"code-embed-wrapper\"> <pre class=\"language-markup code-embed-pre line-numbers\"  data-start=\"1\" data-line-offset=\"0\"><code class=\"language-markup code-embed-code\">c:&gt; &quot;C:\\Program Files\\Microsoft SQL Server\\90\\Tools\\Binn\\OSQL.EXE&quot; -S localhost\\VIM_SQLEXP -E<br\/>1&gt; use VIM_VCDB<br\/>2&gt; go<br\/>1&gt; update vpx_parameter set value=\u2019&lt;value&gt;\u2019 where name=\u2019event.maxAge\u2019<br\/>2&gt; update vpx_parameter set value=\u2019&lt;value&gt;\u2019 where name=\u2019task.maxAge\u2019<br\/>3&gt; update vpx_parameter set value=\u2019true\u2019 where name=\u2019event.maxAgeEnabled\u2019<br\/>4&gt; update vpx_parameter set value=\u2019true\u2019 where name=\u2019task.maxAgeEnabled\u2019<br\/>5&gt; go<br\/>(1 row affected)<br\/>(1 row affected)<br\/>(1 row affected)<br\/>(1 row affected)<br\/>1&gt; exec cleanup_events_tasks_proc<br\/>2&gt; go<br\/>1&gt; dbcc shrinkdatabase (\u2018VIM_VCDB\u2019)<br\/>2&gt; go<\/code><\/pre> <div class=\"code-embed-infos\"> <\/div> <\/div><\/div>\n\n\n\n<p><br>The permanent solution would be to move the SQL server to a full version of SQL Server or to migrate to Vcenter Standalone server ( Hosted on Linux! )&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently a customer had filled up their free SQL Express Database with Events and Tasks from Vmware. The Hosts has both gone to Disconnected with error cannot [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[2443,2442,1955,2441,594],"class_list":["post-3264","post","type-post","status-publish","format-standard","hentry","category-random","tag-failed-because-the-resulting-cumulative-database-size-would-exceed-your-licensed-limit-of-4096-mb-per-database","tag-full","tag-sql-express","tag-vim_vcdb-database-primary-filegroup-is-full","tag-vmware"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=3264"}],"version-history":[{"count":4,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3264\/revisions"}],"predecessor-version":[{"id":6442,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3264\/revisions\/6442"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=3264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=3264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=3264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}