{"id":1497,"date":"2022-04-01T17:06:53","date_gmt":"2022-04-01T17:06:53","guid":{"rendered":"https:\/\/datarebus.com\/?p=1497"},"modified":"2022-04-01T17:06:53","modified_gmt":"2022-04-01T17:06:53","slug":"sql-sunucunuzdaki-log-dosyalarini-nasil-zorla-da-olsa-shrink-edebilirsiniz","status":"publish","type":"post","link":"https:\/\/datarebus.com\/index.php\/2022\/04\/01\/sql-sunucunuzdaki-log-dosyalarini-nasil-zorla-da-olsa-shrink-edebilirsiniz\/","title":{"rendered":"SQL Sunucunuzdaki LOG dosyalar\u0131n\u0131 Nas\u0131l Zorla da Olsa SHRINK edebilirsiniz?"},"content":{"rendered":"\n<pre id=\"tw-target-text\" class=\"wp-block-preformatted\">DBCC SHRINKFILE ile dosyan\u0131z\u0131 k\u00fc\u00e7\u00fcltmek istiyorsunuz ama bir t\u00fcrl\u00fc ba\u015far\u0131ya ula\u015fam\u0131yorsunuz:<\/pre>\n\n\n\n<ol type=\"1\"><li>E\u011fer <strong>Recovery Mode<\/strong> <strong>FULL<\/strong> ise \u00f6ncelikle bunu <strong>SIMPLE<\/strong> yapman\u0131z i\u015fe yarayacakt\u0131r. Tabii burada as\u0131l dikkat edilmesi gereken bu de\u011fi\u015fimin arka planda ba\u015fka i\u015fleri bozmamas\u0131d\u0131r. Zira bu de\u011fi\u015fim <strong>Log Shipping ya da AlwaysOn<\/strong> kurulumunuz var ise bozacakt\u0131r. <strong>Mode <\/strong>de\u011fi\u015fimi sorun yaratsa bile a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 risksiz olarak takip edebilirsiniz.  <\/li><li>Bir Backup \u00e7al\u0131\u015ft\u0131rman\u0131z fayda sa\u011flayacakt\u0131r. FULL ya da TRAN Backup olabilir. <\/li><li>E\u011fer <strong>SHRINK <\/strong>i\u015flemi halen k\u00fc\u00e7\u00fcltme sa\u011flam\u0131yor ise bu a\u00e7\u0131k kalan bir Transaction oldu\u011funa delalettir. Bu &#8220;Active Connection&#8221; bulunup silinmeli. En g\u00fczeli &#8220;CHECKPOINT&#8221; komutu  ile a\u00e7\u0131k t\u00fcm i\u015flemlerin tamamlanmas\u0131 i\u00e7in SQL Sunucumuza bir \u015fans daha vermek. to save all committed transactions.<\/li><\/ol>\n\n\n\n<p><\/p>\n\n\n\n<p>T\u00fcm bu zorlamalar sonucunda SHRINK ba\u015far\u0131l\u0131 olmal\u0131d\u0131r. Ama hala sorun ya\u015f\u0131yorsan\u0131z:  <\/p>\n\n\n\n<p><\/p>\n\n\n\n<ul><li>Komutu direkt olarak de\u011fer vererek \u00e7al\u0131\u015ft\u0131r\u0131n:      DBCC SHRINKFILE (N&#8217;xxxx_log&#8217; , 100)   <\/li><li>TRUNCATEONLY le tekrar deneyin:    DBCC SHRINKFILE (N&#8217;xxx_log&#8217; , 0, TRUNCATEONLY)  <\/li><li>FULL ya da TRANSACTIONAL BACKUP al\u0131p tekrar yukar\u0131daki ad\u0131mlar\u0131 test edin. <\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>E\u00fcer hala sorun ya\u015f\u0131yorsan\u0131z mutlaka a\u00e7\u0131k kalan ve sizin bulamad\u0131\u011f\u0131n\u0131z bir &#8220;Conenction&#8221; vard\u0131r. Bunun i\u00e7in en g\u00fczeli SQL sunucunuzu Restart etmek.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Bol \u015eans..<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>DBCC SHRINKFILE ile dosyan\u0131z\u0131 k\u00fc\u00e7\u00fcltmek istiyorsunuz ama bir t\u00fcrl\u00fc ba\u015far\u0131ya ula\u015fam\u0131yorsunuz: E\u011fer Recovery Mode FULL ise \u00f6ncelikle bunu SIMPLE yapman\u0131z i\u015fe yarayacakt\u0131r. Tabii burada as\u0131l dikkat edilmesi gereken bu de\u011fi\u015fimin arka planda ba\u015fka i\u015fleri bozmamas\u0131d\u0131r. Zira bu de\u011fi\u015fim Log Shipping ya da AlwaysOn kurulumunuz var ise bozacakt\u0131r. Mode de\u011fi\u015fimi sorun yaratsa bile a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 risksiz [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1498,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/1497"}],"collection":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/comments?post=1497"}],"version-history":[{"count":1,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/1497\/revisions"}],"predecessor-version":[{"id":1499,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/1497\/revisions\/1499"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/media\/1498"}],"wp:attachment":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/media?parent=1497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/categories?post=1497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/tags?post=1497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}