{"id":4861,"date":"2008-08-20T13:10:50","date_gmt":"2008-08-20T05:10:50","guid":{"rendered":"https:\/\/www.alfredivy.per.sg\/blogger\/?p=4861"},"modified":"2019-08-03T08:34:30","modified_gmt":"2019-08-03T00:34:30","slug":"taking-a-long-time-view-veritas-job-history","status":"publish","type":"post","link":"https:\/\/www.alfredivy.sg\/blogger\/2008\/08\/taking-a-long-time-view-veritas-job-history\/","title":{"rendered":"Taking a long time view Veritas job history"},"content":{"rendered":"\n<p>If the Symantec Backup Exec job history takes a long to load and when it does, it is blanked. This usually means the database is too large and needs to be compacted.  Use the commands at your own risk.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>This is for Symantec 11d 7170.  At the command prompt, change to Symantec Backup Exec folder.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>osql -E -S localhost\\bkupexec\nuse BEDB\nselect Count(*) from JobHistorySummary\nselect Count(*) from JobHistoryDetailInfo\ngo\ntruncate table JobHistoryDetailInfo\ntruncate table JobHistorysummary\nDBCC SHRINKDATABASE (BEDB,5)\nDBCC CHECKDB\ngo<\/p><\/blockquote>\n\n\n\n<p>This can take some time as the old records get purged.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If the Symantec Backup Exec job history takes a long to load and when it does, it is blanked. This usually means the database is too large and needs to be compacted. Use the commands at your own risk.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[513],"class_list":["post-4861","post","type-post","status-publish","format-standard","hentry","category-data-backup","tag-symantec"],"_links":{"self":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts\/4861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/comments?post=4861"}],"version-history":[{"count":1,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts\/4861\/revisions"}],"predecessor-version":[{"id":4862,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/posts\/4861\/revisions\/4862"}],"wp:attachment":[{"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/media?parent=4861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/categories?post=4861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alfredivy.sg\/blogger\/wp-json\/wp\/v2\/tags?post=4861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}