{"id":177,"date":"2008-04-28T10:56:04","date_gmt":"2008-04-28T18:56:04","guid":{"rendered":"http:\/\/jim-zimmerman.com\/blog\/?p=177"},"modified":"2008-04-28T10:56:04","modified_gmt":"2008-04-28T18:56:04","slug":"used-to-successfully-shrink-a-microsoft-sql-2000-database","status":"publish","type":"post","link":"https:\/\/jim-zimmerman.com\/?p=177","title":{"rendered":"Used to successfully shrink a Microsoft SQL 2000 database."},"content":{"rendered":"<p>Note: I do not believe that I have to do all this, but it did work.  It did not shrink the log using the DBCC commands below as expected.  I will update as learn more, but needed to get this written down, since it did achieve what I had wanted (to reduce the size of the log).<\/p>\n<p>From isql:<br \/>\nDBCC SHRINKFILE(dblogname, size)<br \/>\nBACKUP log dbname WITH TRUNCATE_ONLY<br \/>\nDBCC SHRINKFILE(dblogname, size)<\/p>\n<p>From MSSQL Enterprise manager:<\/p>\n<p><a href='http:\/\/jim-zimmerman.com\/blog\/wp-content\/uploads\/2008\/04\/shrink1.jpg' title='Shrink DB Option in Enterprise Manager'><img src='http:\/\/jim-zimmerman.com\/blog\/wp-content\/uploads\/2008\/04\/shrink1.jpg' alt='Shrink DB Option in Enterprise Manager' \/><\/a><\/p>\n<p><a href='http:\/\/jim-zimmerman.com\/blog\/wp-content\/uploads\/2008\/04\/shrink2.jpg' title='Shrink DB Window'><img src='http:\/\/jim-zimmerman.com\/blog\/wp-content\/uploads\/2008\/04\/shrink2.jpg' alt='Shrink DB Window' \/><\/a><\/p>\n<p><a href='http:\/\/jim-zimmerman.com\/blog\/wp-content\/uploads\/2008\/04\/shrink3.jpg' title='Shrink DB File Window'><img src='http:\/\/jim-zimmerman.com\/blog\/wp-content\/uploads\/2008\/04\/shrink3.jpg' alt='Shrink DB File Window' \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Note: I do not believe that I have to do all this, but it did work. It did not shrink the log using the DBCC commands below as expected. I will update as learn more, but needed to get this written down, since it did achieve what I had wanted (to reduce the size of [&#038;hellip<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-177","post","type-post","status-publish","format-standard","hentry","category-documentation"],"share_on_mastodon":{"url":"","error":""},"_links":{"self":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=177"}],"version-history":[{"count":0,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/177\/revisions"}],"wp:attachment":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}