{"id":544,"date":"2014-03-19T11:05:29","date_gmt":"2014-03-19T08:05:29","guid":{"rendered":"https:\/\/www.ltr.com.tr\/?p=544"},"modified":"2016-03-15T11:28:29","modified_gmt":"2016-03-15T08:28:29","slug":"sql-log-kucultme","status":"publish","type":"post","link":"https:\/\/www.ltr.com.tr\/?p=544","title":{"rendered":"SQL Log K\u00fc\u00e7\u00fcltme"},"content":{"rendered":"<p>Mutlaka data yede\u011fi al\u0131n\u0131z.<\/p>\n<p>One of the SBS servers I look after showed a disk space issue. I had already disabled the WSUS log file, so was a bit puzzled where all the disk space had gone. Upon closer inspection using my favority Treesize tool, I found that the Sharepoint Configuration Database transaction log had grown to 11GB. Well the client uses Sharepoint a bit, but surely this was out of the oridinary on a 160MB DB data file.<\/p>\n<p>I fired up SQL 2005 Express Managment Studio that is installed with SBS (make sure you run as Admin), but was initially unable to connect to the Windows internal database, as it is hidden from general view. However after a bit of googling I found that I had to connect using<\/p>\n<p>\\\\.\\pipe\\MSSQL$MICROSOFT##SSEE\\sql\\query<\/p>\n<p>to access the database. Next I wrote a quick script that shrinks the log file:<\/p>\n<p>USE Master<br \/>\nGO<br \/>\nBACKUP LOG [SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6] WITH TRUNCATE_ONLY<br \/>\nGO<br \/>\nUSE [SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6]<br \/>\nGO<br \/>\nDBCC SHRINKFILE([SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6_log],50)<br \/>\nGO<\/p>\n<p>The Database name may vary from system to system (but appears the same for all SBS 2008 installations), so the above will need to be adjusted to the name of your sharepoint config database name.<\/p>\n<p>While you are there, you may want to check and apply the same fix to the actual Sharepoint Web content database:<br \/>\nUSE Master<br \/>\nGO<br \/>\nBACKUP LOG [ShareWebDb] WITH TRUNCATE_ONLY<br \/>\nGO<br \/>\nUSE [ShareWebDb]<br \/>\nGO<br \/>\nDBCC SHRINKFILE([ShareWebDb_log],50)<br \/>\nGO<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mutlaka data yede\u011fi al\u0131n\u0131z. One of the SBS servers I look after showed a disk space issue. I had already disabled the WSUS log file, so<span class=\"excerpt-hellip\"> [\u2026]<\/span><\/p>\n","protected":false},"author":3,"featured_media":1355,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-544","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-windows"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Log K\u00fc\u00e7\u00fcltme - LTR Bilgi Teknolojileri<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.ltr.com.tr\/?p=544\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Log K\u00fc\u00e7\u00fcltme - LTR Bilgi Teknolojileri\" \/>\n<meta property=\"og:description\" content=\"Mutlaka data yede\u011fi al\u0131n\u0131z. One of the SBS servers I look after showed a disk space issue. I had already disabled the WSUS log file, so [\u2026]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.ltr.com.tr\/?p=544\" \/>\n<meta property=\"og:site_name\" content=\"LTR Bilgi Teknolojileri\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ltrcom\/\" \/>\n<meta property=\"article:published_time\" content=\"2014-03-19T08:05:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-03-15T08:28:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2014\/03\/microsoft-data-platform_1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"708\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Levent Kubilay\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ltrtek\" \/>\n<meta name=\"twitter:site\" content=\"@ltrtek\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Levent Kubilay\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544\"},\"author\":{\"name\":\"Levent Kubilay\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#\\\/schema\\\/person\\\/776594bf41382c96cd738771c19be481\"},\"headline\":\"SQL Log K\u00fc\u00e7\u00fcltme\",\"datePublished\":\"2014-03-19T08:05:29+00:00\",\"dateModified\":\"2016-03-15T08:28:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544\"},\"wordCount\":276,\"publisher\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2014\\\/03\\\/microsoft-data-platform_1.jpg\",\"articleSection\":[\"windows\"],\"inLanguage\":\"tr\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544\",\"url\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544\",\"name\":\"SQL Log K\u00fc\u00e7\u00fcltme - LTR Bilgi Teknolojileri\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2014\\\/03\\\/microsoft-data-platform_1.jpg\",\"datePublished\":\"2014-03-19T08:05:29+00:00\",\"dateModified\":\"2016-03-15T08:28:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544#primaryimage\",\"url\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2014\\\/03\\\/microsoft-data-platform_1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2014\\\/03\\\/microsoft-data-platform_1.jpg\",\"width\":1280,\"height\":708},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/?p=544#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\\\/\\\/www.ltr.com.tr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Log K\u00fc\u00e7\u00fcltme\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#website\",\"url\":\"https:\\\/\\\/www.ltr.com.tr\\\/\",\"name\":\"LTR Bilgi Teknolojileri\",\"description\":\"Yaz\u0131l\u0131m  ve Network \u00c7\u00f6z\u00fcmleri\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.ltr.com.tr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#organization\",\"name\":\"Ltr Bilgi Teknolojileri Ltd. \u015eti.\",\"url\":\"https:\\\/\\\/www.ltr.com.tr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2016\\\/01\\\/yloog.png\",\"contentUrl\":\"https:\\\/\\\/www.ltr.com.tr\\\/wp-content\\\/uploads\\\/2016\\\/01\\\/yloog.png\",\"width\":225,\"height\":91,\"caption\":\"Ltr Bilgi Teknolojileri Ltd. \u015eti.\"},\"image\":{\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/ltrcom\\\/\",\"https:\\\/\\\/x.com\\\/ltrtek\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/ltr-communication-software-desing\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.ltr.com.tr\\\/#\\\/schema\\\/person\\\/776594bf41382c96cd738771c19be481\",\"name\":\"Levent Kubilay\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Log K\u00fc\u00e7\u00fcltme - LTR Bilgi Teknolojileri","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.ltr.com.tr\/?p=544","og_locale":"tr_TR","og_type":"article","og_title":"SQL Log K\u00fc\u00e7\u00fcltme - LTR Bilgi Teknolojileri","og_description":"Mutlaka data yede\u011fi al\u0131n\u0131z. One of the SBS servers I look after showed a disk space issue. I had already disabled the WSUS log file, so [\u2026]","og_url":"https:\/\/www.ltr.com.tr\/?p=544","og_site_name":"LTR Bilgi Teknolojileri","article_publisher":"https:\/\/www.facebook.com\/ltrcom\/","article_published_time":"2014-03-19T08:05:29+00:00","article_modified_time":"2016-03-15T08:28:29+00:00","og_image":[{"width":1280,"height":708,"url":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2014\/03\/microsoft-data-platform_1.jpg","type":"image\/jpeg"}],"author":"Levent Kubilay","twitter_card":"summary_large_image","twitter_creator":"@ltrtek","twitter_site":"@ltrtek","twitter_misc":{"Yazan:":"Levent Kubilay","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.ltr.com.tr\/?p=544#article","isPartOf":{"@id":"https:\/\/www.ltr.com.tr\/?p=544"},"author":{"name":"Levent Kubilay","@id":"https:\/\/www.ltr.com.tr\/#\/schema\/person\/776594bf41382c96cd738771c19be481"},"headline":"SQL Log K\u00fc\u00e7\u00fcltme","datePublished":"2014-03-19T08:05:29+00:00","dateModified":"2016-03-15T08:28:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.ltr.com.tr\/?p=544"},"wordCount":276,"publisher":{"@id":"https:\/\/www.ltr.com.tr\/#organization"},"image":{"@id":"https:\/\/www.ltr.com.tr\/?p=544#primaryimage"},"thumbnailUrl":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2014\/03\/microsoft-data-platform_1.jpg","articleSection":["windows"],"inLanguage":"tr"},{"@type":"WebPage","@id":"https:\/\/www.ltr.com.tr\/?p=544","url":"https:\/\/www.ltr.com.tr\/?p=544","name":"SQL Log K\u00fc\u00e7\u00fcltme - LTR Bilgi Teknolojileri","isPartOf":{"@id":"https:\/\/www.ltr.com.tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.ltr.com.tr\/?p=544#primaryimage"},"image":{"@id":"https:\/\/www.ltr.com.tr\/?p=544#primaryimage"},"thumbnailUrl":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2014\/03\/microsoft-data-platform_1.jpg","datePublished":"2014-03-19T08:05:29+00:00","dateModified":"2016-03-15T08:28:29+00:00","breadcrumb":{"@id":"https:\/\/www.ltr.com.tr\/?p=544#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.ltr.com.tr\/?p=544"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.ltr.com.tr\/?p=544#primaryimage","url":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2014\/03\/microsoft-data-platform_1.jpg","contentUrl":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2014\/03\/microsoft-data-platform_1.jpg","width":1280,"height":708},{"@type":"BreadcrumbList","@id":"https:\/\/www.ltr.com.tr\/?p=544#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.ltr.com.tr\/"},{"@type":"ListItem","position":2,"name":"SQL Log K\u00fc\u00e7\u00fcltme"}]},{"@type":"WebSite","@id":"https:\/\/www.ltr.com.tr\/#website","url":"https:\/\/www.ltr.com.tr\/","name":"LTR Bilgi Teknolojileri","description":"Yaz\u0131l\u0131m  ve Network \u00c7\u00f6z\u00fcmleri","publisher":{"@id":"https:\/\/www.ltr.com.tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.ltr.com.tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/www.ltr.com.tr\/#organization","name":"Ltr Bilgi Teknolojileri Ltd. \u015eti.","url":"https:\/\/www.ltr.com.tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.ltr.com.tr\/#\/schema\/logo\/image\/","url":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/01\/yloog.png","contentUrl":"https:\/\/www.ltr.com.tr\/wp-content\/uploads\/2016\/01\/yloog.png","width":225,"height":91,"caption":"Ltr Bilgi Teknolojileri Ltd. \u015eti."},"image":{"@id":"https:\/\/www.ltr.com.tr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ltrcom\/","https:\/\/x.com\/ltrtek","https:\/\/www.linkedin.com\/company\/ltr-communication-software-desing"]},{"@type":"Person","@id":"https:\/\/www.ltr.com.tr\/#\/schema\/person\/776594bf41382c96cd738771c19be481","name":"Levent Kubilay"}]}},"_links":{"self":[{"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/544","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=544"}],"version-history":[{"count":3,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/544\/revisions"}],"predecessor-version":[{"id":1356,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/posts\/544\/revisions\/1356"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=\/wp\/v2\/media\/1355"}],"wp:attachment":[{"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=544"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=544"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ltr.com.tr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}