{"id":1229,"date":"2014-12-02T16:24:02","date_gmt":"2014-12-02T22:24:02","guid":{"rendered":"http:\/\/it.thelibrarie.com\/weblog\/?p=1229"},"modified":"2014-12-02T16:24:02","modified_gmt":"2014-12-02T22:24:02","slug":"ms-sql-2008-space","status":"publish","type":"post","link":"https:\/\/it.thelibrarie.com\/weblog\/2014\/12\/ms-sql-2008-space\/","title":{"rendered":"MS SQL 2008 Space"},"content":{"rendered":"

So we were getting alerts that our SQL server was running out of space. It was chewing through ~150GB a month.<\/p>\n

Looking into it, we found out that our CRM (MS CRM 4.0) database was the primary culprit.<\/p>\n

\"crm1\"<\/a>
\n* Highlighted portion from another technician<\/p>\n

I finally noticed something a little bit off; the Last Database Log Backup was listed as 9\/24\/2014.
\nIn the SQL Server Management Studio, under Databases, I right-click and choose properties of the CRM database
\nI then selected the Files page (left side)
\nThe PRIMARY rows data mdf was 56GB
\nThe Log ldf was ~185GB<\/p>\n

That might explain it!<\/p>\n

So we went back and looked through the notes regarding this server. We had changed the Recovery Model to Full (same location under the Options page) in order to export a copy for our development environment. And this was never changed back.<\/p>\n

Change this setting back to Simple and hit OK.
\nThen Right-click on the same database and choose Tasks, Shrink, Files
\nFile type change to Log<\/p>\n

In my case it showed available freespace of 99%. I clicked OK and the data usage went down to 1.25GB. Pretty big savings if you ask me.<\/p>\n","protected":false},"excerpt":{"rendered":"

So we were getting alerts that our SQL server was running out of space. It was chewing through ~150GB a month. Looking into it, we found out that our CRM (MS CRM 4.0) database was the primary culprit. * Highlighted portion from another technician I finally noticed something a little bit off; the Last Database … Continue reading MS SQL 2008 Space<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1229","post","type-post","status-publish","format-standard","hentry","category-microsoft"],"_links":{"self":[{"href":"https:\/\/it.thelibrarie.com\/weblog\/wp-json\/wp\/v2\/posts\/1229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/it.thelibrarie.com\/weblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/it.thelibrarie.com\/weblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/it.thelibrarie.com\/weblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/it.thelibrarie.com\/weblog\/wp-json\/wp\/v2\/comments?post=1229"}],"version-history":[{"count":1,"href":"https:\/\/it.thelibrarie.com\/weblog\/wp-json\/wp\/v2\/posts\/1229\/revisions"}],"predecessor-version":[{"id":1231,"href":"https:\/\/it.thelibrarie.com\/weblog\/wp-json\/wp\/v2\/posts\/1229\/revisions\/1231"}],"wp:attachment":[{"href":"https:\/\/it.thelibrarie.com\/weblog\/wp-json\/wp\/v2\/media?parent=1229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/it.thelibrarie.com\/weblog\/wp-json\/wp\/v2\/categories?post=1229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/it.thelibrarie.com\/weblog\/wp-json\/wp\/v2\/tags?post=1229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}