{"id":1954,"date":"2017-01-30T17:54:48","date_gmt":"2017-01-30T17:54:48","guid":{"rendered":"http:\/\/obieta.com\/?p=1954"},"modified":"2017-01-30T17:54:48","modified_gmt":"2017-01-30T17:54:48","slug":"shrink-large-sql-ldf-log-files","status":"publish","type":"post","link":"http:\/\/obieta.com\/?p=1954","title":{"rendered":"Shrink Large SQL LDF Log Files"},"content":{"rendered":"<p>In\u00a0 Server Management Studio Right click on the database in question and go to Properties:<\/p>\n<ul>\n<li>Go to &#8220;Options&#8221; on the left<\/li>\n<li>Change the line &#8220;Recovery Model:&#8221; from Full to &#8220;Simple&#8221; and hit OK<\/li>\n<li>Right click on the database again, go to Tasks &#8211; Shrink &#8211; Files<\/li>\n<li>Under File Type: select Log and click OK<\/li>\n<\/ul>\n<p>This will temporarily free up space for you, make sure that your database is set to back up and that its configured to empty the log after back up. Once you have resolved the space issue and made sure your log file is set to flush after backups, I recommend you put the recovery model back on Full.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In\u00a0 Server Management Studio Right click on the database in question and go to Properties: Go to &#8220;Options&#8221; on the left Change the line &#8220;Recovery Model:&#8221; from Full to &#8220;Simple&#8221; and hit OK Right click on the database again, go to Tasks &#8211; Shrink &#8211; Files Under File Type: select Log and click OK This [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts\/1954"}],"collection":[{"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1954"}],"version-history":[{"count":0,"href":"http:\/\/obieta.com\/index.php?rest_route=\/wp\/v2\/posts\/1954\/revisions"}],"wp:attachment":[{"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1954"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/obieta.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}