{"id":92,"date":"2013-12-13T01:18:12","date_gmt":"2013-12-13T01:18:12","guid":{"rendered":"http:\/\/www.torontohelpdesk.ca\/blog\/?p=92"},"modified":"2014-05-12T14:21:05","modified_gmt":"2014-05-12T14:21:05","slug":"sbsmonitoring-is-too-large","status":"publish","type":"post","link":"https:\/\/www.torontohelpdesk.ca\/blog\/sbsmonitoring-is-too-large\/","title":{"rendered":"SBSMonitoring is too large"},"content":{"rendered":"

Problem:<\/strong><\/p>\n

SBSMonitoring DB is way too large. The autoclean process of Windows sometimes malfunctions, go figure.<\/p>\n

Solution 1:<\/strong><\/p>\n

To expedite the process, I would first stop the SQL SBS service.<\/p>\n

When you run the command, make sure you preface it with .\\<\/p>\n

http:\/\/blogs.technet.com\/b\/sbs\/archive\/2011\/08\/22\/how-to-recreate-the-sbsmonitoring-database.aspx<\/p>\n

Solution 2:<\/strong><\/p>\n

1. Stop the SQL SBS service first
\n2. Go to C:\\Program Files (x86)\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data
\n3. Rename the files to a .bak or something
\n4. Download and unzip the following files into the same directory sbsmonitoring<\/a>
\n5. Start the service
\n6. Delete the files after a couple of days or at least move them elsewhere if you have a space issue<\/p>\n

Update<\/span><\/strong><\/p>\n

Optional:<\/strong><\/p>\n

    \n
  1. Open IIS<\/li>\n
  2. Drill down until you have Default Web Site selected<\/li>\n
  3. In the features view (center selection), scroll down until you see Logging (Health and Diagnostics)<\/li>\n
  4. Double click on Logging<\/li>\n
  5. Click on Disable<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Problem: SBSMonitoring DB is way too large. The autoclean process of Windows sometimes malfunctions, go figure. Solution 1: To expedite the process, I would first stop the SQL SBS service. When you run the command, make sure you preface it Continue reading SBSMonitoring is too large<\/span>→<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,24,30,29],"tags":[],"class_list":["post-92","post","type-post","status-publish","format-standard","hentry","category-sbs-2008","category-sbs-2011","category-sbs-monitoring","category-sql"],"_links":{"self":[{"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/posts\/92","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/comments?post=92"}],"version-history":[{"count":6,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/posts\/92\/revisions"}],"predecessor-version":[{"id":120,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/posts\/92\/revisions\/120"}],"wp:attachment":[{"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/media?parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/categories?post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.torontohelpdesk.ca\/blog\/wp-json\/wp\/v2\/tags?post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}