{"id":237,"date":"2018-03-25T11:05:12","date_gmt":"2018-03-25T11:05:12","guid":{"rendered":"http:\/\/www.eyurtsever.com\/?p=237"},"modified":"2023-01-11T15:45:09","modified_gmt":"2023-01-11T12:45:09","slug":"mssql-2008-veritabani-loglarini-temizlemek","status":"publish","type":"post","link":"https:\/\/www.eyurtsever.com\/index.php\/mssql-2008-veritabani-loglarini-temizlemek","title":{"rendered":"MSSQL 2008 Veritaban\u0131 Loglar\u0131n\u0131 Temizlemek"},"content":{"rendered":"<p>Mssql 2008 <a title=\"Veritaban\u0131 Loglar\u0131n\u0131 Temizlemek\" href=\"http:\/\/www.eyurtsever.com\/index.php\/mssql-2008-veritabani-loglarini-temizlemek\">veritaban\u0131ndaki loglar\u0131 temizlemek<\/a> \u00e7ok kolay. K\u00fc\u00e7\u00fck bir sql sorgusu yazarak veritaban\u0131m\u0131z\u0131n \u015fi\u015fen loglar\u0131ndan kurtulabiliriz. A\u015fa\u011f\u0131daki <a title=\"Sql Sorgusu\" href=\"http:\/\/www.eyurtsever.com\/index.php\/mssql-2008-veritabani-loglarini-temizlemek\">sql sorgusunu temizlemek<\/a> istedi\u011finiz veritaban\u0131 ismini yazarak uygulay\u0131n.<br \/>\n&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\">USE veritabaniadi\nGO\nALTER DATABASE veritabaniadi SET RECOVERY SIMPLE WITH NO_WAIT\nDBCC SHRINKFILE(veritabani_log)\nALTER DATABASE veritabaniadi SET RECOVERY FULL WITH NO_WAIT\nGO<\/pre>\n<p>&nbsp;<br \/>\nveritaban\u0131 ad\u0131 yazan yere kendi veritaban\u0131 ad\u0131n\u0131z\u0131 yaz\u0131n. veritaban\u0131_log &nbsp;yazan yere log dosyas\u0131n\u0131n ad\u0131n\u0131 yaz\u0131n. Log dosyas\u0131n\u0131n ad\u0131n\u0131 \u00f6\u011frenmek i\u00e7in;<br \/>\nVeritaban\u0131na sa\u011f t\u0131klay\u0131n <strong>Properties &gt; Files<\/strong> &nbsp;sekmesinde log dosyas\u0131 ismini g\u00f6rebilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mssql 2008 veritaban\u0131ndaki loglar\u0131 temizlemek \u00e7ok kolay. K\u00fc\u00e7\u00fck bir sql sorgusu yazarak veritaban\u0131m\u0131z\u0131n \u015fi\u015fen loglar\u0131ndan kurtulabiliriz. A\u015fa\u011f\u0131daki sql sorgusunu temizlemek istedi\u011finiz veritaban\u0131 ismini yazarak uygulay\u0131n. &nbsp; USE veritabaniadi GO ALTER DATABASE veritabaniadi SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(veritabani_log) ALTER DATABASE veritabaniadi SET RECOVERY FULL WITH NO_WAIT GO &nbsp; veritaban\u0131 ad\u0131 yazan yere kendi veritaban\u0131 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[12],"tags":[197,198,202,214,296,300],"_links":{"self":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/237"}],"collection":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/comments?post=237"}],"version-history":[{"count":1,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/237\/revisions"}],"predecessor-version":[{"id":614,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/posts\/237\/revisions\/614"}],"wp:attachment":[{"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/media?parent=237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/categories?post=237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.eyurtsever.com\/index.php\/wp-json\/wp\/v2\/tags?post=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}