{"id":11570,"date":"2019-04-13T10:10:19","date_gmt":"2019-04-13T10:10:19","guid":{"rendered":"https:\/\/dbtut.com\/?p=11570"},"modified":"2019-04-13T10:10:19","modified_gmt":"2019-04-13T10:10:19","slug":"how-to-check-sql-server-error-logs-and-operations-system-logs","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/","title":{"rendered":"How To Check SQL Server Error Logs and Operations System Logs"},"content":{"rendered":"

SQL Server Logs and Operating System Logs(Event Logs) are logs that SQL Server Database Administrators checks on a daily basis, or use to find the cause of the error when they encounter an error. In this article, we will learn how to check these logs.<\/p>\n

Through SSMS, you can access both logs from the View tab by right-clicking SQL Server Logs under Management as follows.<\/p>\n

\"\"<\/p>\n

You can also access the operating system logs from the Event Viewer on Windows. To access the event viewer,  go to Run->Search and write “Event Viewer”.<\/p>\n

\"\"<\/p>\n

When we open the Event Viewer, a screen appears as below. You can find logs from the tabs under Windows Logs.<\/p>\n

\"\"<\/p>\n

If you want to filter SQL Server Error Log, I suggest you to read the below article.<\/p>\n

“How To Filter SQL Server Error Log(Like or Not Like)<\/a>”<\/p>\n\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

SQL Server Logs and Operating System Logs(Event Logs) are logs that SQL Server Database Administrators checks on a daily basis, or use to find the cause of the error when they encounter an error. In this article, we will learn how to check these logs. Through SSMS, you can access both logs from the View …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":11578,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3,1524],"tags":[3360,3361,3354,3362,3359,3353,3352,3357,3356,3351,3342,3349,3348,3345,3344,3343,3346,3350,3358,3347,3355],"class_list":["post-11570","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","category-windows","tag-check-sql-server-error-logs","tag-check-sql-server-logs","tag-how-do-i-access-event-viewer","tag-how-do-i-access-the-event-log","tag-how-do-i-check-server-logs","tag-how-do-i-find-windows-event-log","tag-how-do-i-open-event-viewer-from-run","tag-how-do-i-open-sql-server-error-logs","tag-how-do-i-open-windows-error-logs","tag-how-do-i-see-application-errors-in-event-viewer","tag-how-do-i-view-sql-server-logs","tag-query-windows-event-log-from-sql-server","tag-sql-server-error-log-query","tag-troubleshooting-microsoft-sql-server","tag-view-the-sql-server-error-log","tag-what-is-sql-server-error-log","tag-where-is-errorlog-in-sql-server","tag-where-is-event-viewer","tag-where-is-sql-server-error-logs","tag-where-is-sql-server-errorlog","tag-where-is-windows-error-logs"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":4617,"today_views":0},"yoast_head":"\nHow To Check SQL Server Error Logs and Operations System Logs - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Check SQL Server Error Logs and Operations System Logs\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Check SQL Server Error Logs and Operations System Logs - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Check SQL Server Error Logs and Operations System Logs\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-13T10:10:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-28.png\" \/>\n\t<meta property=\"og:image:width\" content=\"518\" \/>\n\t<meta property=\"og:image:height\" content=\"298\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Check SQL Server Error Logs and Operations System Logs\",\"datePublished\":\"2019-04-13T10:10:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/\"},\"wordCount\":158,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-28.png\",\"keywords\":[\"check sql server error logs\",\"check sql server logs\",\"How do I access event viewer?\",\"How do I access the event log?\",\"How do I check server logs?\",\"How do I find Windows event log?\",\"How do I open Event Viewer from run?\",\"how do I open sql server error logs\",\"How do I open windows error logs\",\"How do I see application errors in event viewer?\",\"How do I view SQL Server logs?\",\"query windows event log from sql server\",\"sql server error log query\",\"Troubleshooting Microsoft SQL Server\",\"View the SQL Server error log\",\"What is SQL Server error log?\",\"Where is ERRORLOG in SQL Server?\",\"Where is event viewer?\",\"where is sql server error logs\",\"Where is SQL Server ERRORLOG?\",\"Where is windows error logs?\"],\"articleSection\":[\"MSSQL\",\"Windows\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/\",\"name\":\"How To Check SQL Server Error Logs and Operations System Logs - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-28.png\",\"datePublished\":\"2019-04-13T10:10:19+00:00\",\"description\":\"How To Check SQL Server Error Logs and Operations System Logs\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-28.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-28.png\",\"width\":518,\"height\":298},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Check SQL Server Error Logs and Operations System Logs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Check SQL Server Error Logs and Operations System Logs - Database Tutorials","description":"How To Check SQL Server Error Logs and Operations System Logs","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:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/","og_locale":"en_US","og_type":"article","og_title":"How To Check SQL Server Error Logs and Operations System Logs - Database Tutorials","og_description":"How To Check SQL Server Error Logs and Operations System Logs","og_url":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/","og_site_name":"Database Tutorials","article_published_time":"2019-04-13T10:10:19+00:00","og_image":[{"width":518,"height":298,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-28.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Check SQL Server Error Logs and Operations System Logs","datePublished":"2019-04-13T10:10:19+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/"},"wordCount":158,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-28.png","keywords":["check sql server error logs","check sql server logs","How do I access event viewer?","How do I access the event log?","How do I check server logs?","How do I find Windows event log?","How do I open Event Viewer from run?","how do I open sql server error logs","How do I open windows error logs","How do I see application errors in event viewer?","How do I view SQL Server logs?","query windows event log from sql server","sql server error log query","Troubleshooting Microsoft SQL Server","View the SQL Server error log","What is SQL Server error log?","Where is ERRORLOG in SQL Server?","Where is event viewer?","where is sql server error logs","Where is SQL Server ERRORLOG?","Where is windows error logs?"],"articleSection":["MSSQL","Windows"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/","url":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/","name":"How To Check SQL Server Error Logs and Operations System Logs - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-28.png","datePublished":"2019-04-13T10:10:19+00:00","description":"How To Check SQL Server Error Logs and Operations System Logs","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-28.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-28.png","width":518,"height":298},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Check SQL Server Error Logs and Operations System Logs"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11570","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=11570"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11570\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11578"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11570"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11570"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}