{"id":2928,"date":"2020-03-25T12:41:21","date_gmt":"2020-03-25T07:11:21","guid":{"rendered":"https:\/\/www.24x7serversupport.com\/blog\/?p=2928"},"modified":"2020-03-25T12:41:24","modified_gmt":"2020-03-25T07:11:24","slug":"sql-server-error-log-consuming-lots-of-disk-space","status":"publish","type":"post","link":"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/","title":{"rendered":"SQL Server Error Log Consuming Lots of Disk Space"},"content":{"rendered":"\n<p> C:\\Program Files\\Microsoft SQL Server\\MSSQL11.SQLSERVER2012\\MSSQL\\Log <br>Error logs files are consuming high disk space. <\/p>\n\n\n\n<p><strong>We can recycle the SQL Server Error Log using sp_cycle_errorlog<\/strong><\/p>\n\n\n\n<p>You can view the logs and their contents in Management Studio by  accessing the \u201cManagement\u201d node and by either double clicking or right  clicking the logs.<\/p>\n\n\n\n<p>Open management studio, new query and run &#8221; <strong>sp_cycle_errorlog<\/strong> &#8221;  Each time you run this command, a new log is created and the existing  logs are cycled until the max number of allowed error logs is reached.  \u00a0So you get ErrorLog.1, ErrorLog.2 etc in your log directory. When the  max logs is reached, the oldest file is removed. <\/p>\n\n\n\n<p> You can adjust the number of log files to be retained, the minimum is 6  and the maxium is 99 and this can be configured by right clicking the  SQL Server Logs node and choosing the configure option. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>C:\\Program Files\\Microsoft SQL Server\\MSSQL11.SQLSERVER2012\\MSSQL\\Log Error logs files are consuming high disk space. We can recycle the SQL Server Error Log using sp_cycle_errorlog You can view the logs and their contents in Management Studio by accessing the \u201cManagement\u201d node and by either double clicking or right clicking the logs. Open management studio, new query and run [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1,37],"tags":[],"class_list":["post-2928","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-windows"],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server Error Log Consuming Lots of Disk Space | 24x7serversupport Blog<\/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.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Error Log Consuming Lots of Disk Space | 24x7serversupport Blog\" \/>\n<meta property=\"og:description\" content=\"C:Program FilesMicrosoft SQL ServerMSSQL11.SQLSERVER2012MSSQLLog Error logs files are consuming high disk space. We can recycle the SQL Server Error Log using sp_cycle_errorlog You can view the logs and their contents in Management Studio by accessing the \u201cManagement\u201d node and by either double clicking or right clicking the logs. Open management studio, new query and run [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/\" \/>\n<meta property=\"og:site_name\" content=\"24x7serversupport Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-25T07:11:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-25T07:11:24+00:00\" \/>\n<meta name=\"author\" content=\"24x7support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:site\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"24x7support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/\",\"name\":\"SQL Server Error Log Consuming Lots of Disk Space | 24x7serversupport Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\"},\"datePublished\":\"2020-03-25T07:11:21+00:00\",\"dateModified\":\"2020-03-25T07:11:24+00:00\",\"author\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.24x7serversupport.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Error Log Consuming Lots of Disk Space\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/\",\"name\":\"24x7serversupport Blog\",\"description\":\"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\",\"name\":\"24x7support\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Error Log Consuming Lots of Disk Space | 24x7serversupport Blog","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.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Error Log Consuming Lots of Disk Space | 24x7serversupport Blog","og_description":"C:Program FilesMicrosoft SQL ServerMSSQL11.SQLSERVER2012MSSQLLog Error logs files are consuming high disk space. We can recycle the SQL Server Error Log using sp_cycle_errorlog You can view the logs and their contents in Management Studio by accessing the \u201cManagement\u201d node and by either double clicking or right clicking the logs. Open management studio, new query and run [&hellip;]","og_url":"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/","og_site_name":"24x7serversupport Blog","article_published_time":"2020-03-25T07:11:21+00:00","article_modified_time":"2020-03-25T07:11:24+00:00","author":"24x7support","twitter_card":"summary_large_image","twitter_creator":"@24x7serversuppo","twitter_site":"@24x7serversuppo","twitter_misc":{"Written by":"24x7support","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/","url":"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/","name":"SQL Server Error Log Consuming Lots of Disk Space | 24x7serversupport Blog","isPartOf":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#website"},"datePublished":"2020-03-25T07:11:21+00:00","dateModified":"2020-03-25T07:11:24+00:00","author":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401"},"breadcrumb":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.24x7serversupport.com\/blog\/sql-server-error-log-consuming-lots-of-disk-space\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.24x7serversupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Error Log Consuming Lots of Disk Space"}]},{"@type":"WebSite","@id":"https:\/\/www.24x7serversupport.com\/blog\/#website","url":"https:\/\/www.24x7serversupport.com\/blog\/","name":"24x7serversupport Blog","description":"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401","name":"24x7support","url":"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2928","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/comments?post=2928"}],"version-history":[{"count":1,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2928\/revisions"}],"predecessor-version":[{"id":2929,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2928\/revisions\/2929"}],"wp:attachment":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media?parent=2928"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/categories?post=2928"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/tags?post=2928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}