{"id":3514,"date":"2018-07-26T01:22:50","date_gmt":"2018-07-26T01:22:50","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=3514"},"modified":"2018-07-26T01:22:50","modified_gmt":"2018-07-26T01:22:50","slug":"n-able-report-manager-maintenance-reduce-database-size","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/random\/n-able-report-manager-maintenance-reduce-database-size","title":{"rendered":"N-able Report Manager Maintenance &#8211; Reduce Database Size"},"content":{"rendered":"<p>Login to the Nable\u00a0Administrator Report Manager (\u00a0http:\/\/%reportmanagerserver%\/Interface\/Pages\/menu.aspx )\u00a0<\/p><p>You will need to use the username :\u00a0<strong>reportsadmin@n-able.co<\/strong>m ( <a href=\"https:\/\/secure.n-able.com\/webhelp\/ReportManager_4-3-3_AC_en\/Content\/AdminConsole\/AC_Access_Recovery.html\">You can reset this password<\/a> )\u00a0<\/p><p>Navigate to the following<\/p><ol><li>Select\u00a0<b>System Setup and Logs<\/b><\/li><li>Select\u00a0<b>Data Retention settings<\/b><\/li><\/ol><p>Depending on your retention modify the below per\u00a0<a href=\"https:\/\/support.solarwindsmsp.com\/kb\/solarwinds_n-central\/Report-Manager-Disk-Space-Disk-is-running-out-of-space\">here<\/a><\/p><p id=\"pyTBPzg\"><img loading=\"lazy\" decoding=\"async\" width=\"879\" height=\"500\" class=\"alignnone size-full wp-image-3516  img-responsive\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/07\/img_5b5920987eb74.png\" alt=\"\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/07\/img_5b5920987eb74.png 879w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/07\/img_5b5920987eb74-300x171.png 300w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/07\/img_5b5920987eb74-768x437.png 768w\" sizes=\"auto, (max-width: 879px) 100vw, 879px\" \/><\/p><p>Open SQL Server Management Studio make sure you have maintenance plan set up on the ODS Database<\/p><p id=\"smzDMUV\"><img loading=\"lazy\" decoding=\"async\" width=\"267\" height=\"130\" class=\"alignnone size-full wp-image-3515  img-responsive\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2018\/07\/img_5b591dfe658ea.png\" alt=\"\" \/><\/p><ul><li>Set the following in the Maintenance Plan Wizard of Microsoft SQL Server Management Studio:<\/li><li>\u00a0Set the plan properties Name to Report Manager and Daily Run out of hours\u00a0<br \/><br \/>2. Select the following maintenance tasks for the ODS databases and the warehouse database<\/li><li>Check Database Integrity<\/li><li>Reorganize Index<\/li><li>Update Statistics<\/li><\/ul><p>If you backup via another utility you can cancel the below :\u00a0<\/p><ul><li>Back Up Database (Full)<\/li><li>Maintenance Cleanup Task<\/li><\/ul><p>After the maintenance plan ran , we ran a Shrink on the database to reduce a 400GB Database file back down to 50GB for 3000 Devices<\/p><p>*SolarWinds MSP does not recommend shrinking your database.* however this was needed due to the ODS build up<\/p>","protected":false},"excerpt":{"rendered":"<p>Login to the Nable\u00a0Administrator Report Manager (\u00a0http:\/\/%reportmanagerserver%\/Interface\/Pages\/menu.aspx )\u00a0You will need to use the username :\u00a0reportsadmin@n-able.com ( You can reset this password )\u00a0Navigate to the followingSelect\u00a0System Setup and [&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":[2578,2581,2579,1479,2580,2582,2577,1267,591],"class_list":["post-3514","post","type-post","status-publish","format-standard","hentry","category-random","tag-big-database","tag-large-size","tag-maintenance-plan","tag-n-able","tag-ods","tag-reduce-file-size","tag-report-manager","tag-solarwinds","tag-sql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3514","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=3514"}],"version-history":[{"count":1,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3514\/revisions"}],"predecessor-version":[{"id":3517,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/3514\/revisions\/3517"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=3514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=3514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=3514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}