{"id":1286,"date":"2014-11-04T21:50:13","date_gmt":"2014-11-04T13:50:13","guid":{"rendered":"http:\/\/nick.txtcc.com\/?p=1286"},"modified":"2015-06-05T14:33:50","modified_gmt":"2015-06-05T06:33:50","slug":"mssql-log-clear-and-shrink-file","status":"publish","type":"post","link":"http:\/\/nick.txtcc.com\/index.php\/db\/1286","title":{"rendered":"mssql log clear and shrink file"},"content":{"rendered":"<pre lang=\"csharp\" line=\"1\" escaped=\"true\">ALTER DATABASE testdb SET RECOVERY SIMPLE WITH NO_WAIT\nDBCC SHRINKFILE(testdb, 1)\nDBCC SHRINKFILE(testdb_log, 1)\nALTER DATABASE testdb SET RECOVERY FULL WITH NO_WAIT<\/pre>","protected":false},"excerpt":{"rendered":"<p>ALTER DATABASE testdb SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(testdb, 1) DBCC SHRINKFILE(te&#46;&#46;&#46;<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101],"tags":[352,401],"class_list":["post-1286","post","type-post","status-publish","format-standard","hentry","category-db","tag-log","tag-mssql"],"_links":{"self":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/comments?post=1286"}],"version-history":[{"count":5,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1286\/revisions"}],"predecessor-version":[{"id":1315,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/1286\/revisions\/1315"}],"wp:attachment":[{"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/media?parent=1286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/categories?post=1286"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/tags?post=1286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}