{"id":15925,"date":"2018-02-12T11:24:13","date_gmt":"2018-02-12T11:24:13","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=15925"},"modified":"2025-08-22T06:38:16","modified_gmt":"2025-08-22T06:38:16","slug":"how-to-fix-sql-server-error-823","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/","title":{"rendered":"How to Fix SQL Server Database Fatal Error 823?"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><h2 class=\"wp-block-heading\" id=\"what-is&nbsp;sql-error-823?\"><strong>What is&nbsp;SQL error 823?<\/strong><\/h2><p>A SQL Server database encounters error 823 when an I\/O operation (read or write request) fails. This usually happens due to issues with the operating system, drivers, or hardware issues. The SQL error 823 may also occur due to inconsistencies in the file system or a corrupted database file.<\/p><p>The complete text of the SQL 823 error message looks similar to: <\/p><figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><th><span style=\"color: #FF0000\">Error: 823, Severity: 24, State: 2.<\/span><br><span style=\"color: #FF0000\"> 2010-03-06 22:41:19.55 spid58 The operating system returned error 38 (Reached the end of the file.) to SQL Server during a read at offset 0x000000a72c0000 in file &lsquo;C:\\Program Files\\Microsoft SQL Server\\ MSSQL\\DATA\\db.mdf&rsquo;. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe, system-level error condition that threatens database integrity and must be corrected immediately. It is recommended to complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online<\/span><\/th><\/tr><\/tbody><\/table><\/figure><p>In the error message, 823 is the error code. The severity level 24 means that the error occurred due to problems with the hardware or software. The state 2 is used to differentiate the error from other errors with the same number but in a different state.<\/p><p>Further, the error provides the following information:<\/p><ul class=\"wp-block-list\">\n<li>The data file (usually a .MDF file) against which the I\/O (read or write) operation was performed.<\/li>\n\n\n\n<li>The offset, i.e., the physical byte offset from the start of the file, dividing it by 8192 will help you find the logical page number that is corrupted due to the error.<\/li>\n\n\n\n<li>Identifies whether a read or write request was made to a device.<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"what-problems-are-associated-with-the-823-io-error?\"><strong>What problems are associated with the 823 IO error?<\/strong><\/h2><p>This problem can be related to the following problems:<\/p><ol class=\"wp-block-list\">\n<li>A Torn Page<\/li>\n\n\n\n<li>Bad Page ID<\/li>\n\n\n\n<li>Insufficient bytes transferred<\/li>\n<\/ol><h2 class=\"wp-block-heading\" id=\"what-is-a-torn-page?\"><strong>What is a torn page?<\/strong><\/h2><p>It is a page that was incorrectly written. We could say <a rel=\"noreferrer noopener nofollow\" href=\"https:\/\/www.linkedin.com\/pulse\/sql-database-torn-page-detection-repair-priyanka-chouhan\/\" target=\"_blank\">Torn Page Detection<\/a>&nbsp;writes a bit for every 512 bytes on the page. It helps detect a page that is not successfully written to disk. But, it does not tell if the data stored to disk is actually correct as a couple of bytes may have been written incorrectly.<\/p><h3 class=\"wp-block-heading\" id=\"h-what-is-the-error-message-for-the-torn-page-error\"><strong>What is the error message for the torn page error?<\/strong><\/h3><p>The error will be like this one:<\/p><figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><th><p style=\"text-align: justify\"><span style=\"color: #FF0000\">2015-08-05 16:51:18.90 spid17 Error: 823, Severity: 24, State: 2 <\/span><br><span style=\"color: #FF0000\"> 2015-08-05 16:51:18.90 spid17 I\/O errors (torn page) detected during read at offset 0x00000094004000 in file &lsquo;c:\\Program Files\\Microsoft SQL Server\\MSSQL\\data\\tempdb.mdf&rsquo;<\/span><\/p><\/th><\/tr><\/tbody><\/table><\/figure><h3 class=\"wp-block-heading\" id=\"h-how-can-i-detect-torn-page-io-error\"><strong>How can I detect torn page IO error?<\/strong><\/h3><p>You can detect these errors when you run the CHECKDB command in your database.<\/p><h2 class=\"wp-block-heading\" id=\"what-is-bad-page-id?\"><strong>What is Bad Page ID?<\/strong><\/h2><p>It is when the header page ID is not the same as the expended one when reading in the disk.<\/p><h3 class=\"wp-block-heading\" id=\"h-why-is-the-error-insufficient-bytes-transferred-produced-in-sql-server\"><span style=\"color: #000000\"><strong>Why is the error insufficient bytes transferred produced in SQL Server?<\/strong><\/span><\/h3><p>It means that the API call was invoked successfully, but the bytes transferred are not the expected ones.<\/p><h3 class=\"wp-block-heading\" id=\"h-how-to-solve-sql-server-error-823\"><strong>How to solve SQL Server error 823 ?<\/strong><\/h3><p>The first step would be to run a&nbsp;<a href=\"https:\/\/www.stellarinfo.com\/blog\/how-to-repair-sql-database-using-dbcc-checkdb-command\/\">DBCC CHECKDB command<\/a>&nbsp;and check if it returns consistency errors. If it does, try to restore your database from a backup. Once the database is restored, run a CHECKDB to verify that the problem is solved.<\/p><p>If the problem persists or backup is not available, try to repair the database using the following T-SQL statement:<\/p><pre class=\"wp-block-code command_container\"><code>DBCC CHECKDB (DB_NAME, REPAIR_REBUILD);<\/code><\/pre><p>To repair the database, you must restrict its usage to a single user. This requires changing the database state to Single-user mode. To do so, run the following T-SQL query:<\/p><pre class=\"wp-block-code command_container\"><code>ALTER DATABASE DB2 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;<\/code><\/pre><p>You can also set the database to a Single-user using the point-in-click interface in SQL Server Management Studio (SSMS). For this, right-click on the database in SSMS and go to the <strong>Options <\/strong>page. On the <strong>&lsquo;Options&rsquo;<\/strong> page, choose the <strong>SINGLE USER<\/strong> option from the <strong>Restrict Access<\/strong> drop-down box, then click <strong>OK<\/strong>.<\/p><figure class=\"wp-block-image wp-image-15941 size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"692\" height=\"622\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/Set-database-in-Single-user-mode.jpg\" alt=\"SQL Server error 823\" class=\"wp-image-15941 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/Set-database-in-Single-user-mode.jpg 692w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/Set-database-in-Single-user-mode-300x270.jpg 300w\" sizes=\"auto, (max-width: 692px) 100vw, 692px\" \/><\/figure><p>After setting the database to Single_user mode, repair the database, and run<strong> &lsquo;DBCC CHECKDB&rsquo;<\/strong> again to verify that the database was repaired.<\/p><blockquote class=\"note_alert\">\n<p><strong>Note:<\/strong> If the error persists, an issue with the hardware might have caused SQL error 823. In that case, you will need to repair your hard disk. Contact the IT members in charge of the hardware. Check also if there are fragmentation problems in the hard disk.<\/p>\n<\/blockquote><p>If you have a Torn page error, you can use the CHECKSUM and the torn page detection to repair and verify the errors.<\/p><h3 class=\"wp-block-heading\" id=\"h-what-else-you-can-do-to-resolve-sql-error-823\"><strong>What Else You Can Do to Resolve SQL Error 823?<\/strong><\/h3><p>Use <strong>Stellar Repair for MS SQL <\/strong>to fix database consistency errors reported by DBCC CHECKDB and preview the recoverable data. This <a href=\"https:\/\/www.stellarinfo.com\/sql-database-repair.php\" target=\"_blank\" rel=\"noreferrer noopener\">SQL repair tool<\/a>&nbsp; can be downloaded from the link below.<\/p><div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/cloud.stellarinfo.com\/StellarRepairforMSSQL-Blog.exe\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/images\/free-download-windows.png\" alt=\"free download\"><\/a><\/figure>\n<\/div><p>This software will repair the .MDF\/.NDF files of SQL Server database. Before using the software, make sure to stop the SQL Server Service first. It is recommended to stop the service using the SQL Server Management Studio (SSMS) or the SQL Server Configuration Manager.<\/p><figure class=\"wp-block-image size-large\"><img decoding=\"async\" class=\"apply-gradient-on-post-images\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/stop-ssql-server-service.jpg\" alt=\"stop SQL server service\"><\/figure><p>Now follow these steps to repair and recover your SQL database file:<\/p><ul class=\"wp-block-list\">\n<li>Browse or search the corrupt .MDF file.<\/li>\n\n\n\n<li>Once the .MDF file is uploaded, press the&nbsp;<strong>Repair<\/strong>&nbsp;button.<\/li>\n<\/ul><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"967\" height=\"622\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/select-corrupt-mdf-file-image.png\" alt=\"select corrupt mdf file\" class=\"wp-image-85954 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/select-corrupt-mdf-file-image.png 967w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/select-corrupt-mdf-file-image-300x193.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/select-corrupt-mdf-file-image-768x494.png 768w\" sizes=\"auto, (max-width: 967px) 100vw, 967px\" \/><\/figure><p><strong>Note:<\/strong><strong>&nbsp;If you have one or multiple secondary data files (.NDF file) associated with your database, then put all the NDF files at the location of the MDF file. Once everything is done, you can restart the SQL Server Service and rerun the CHECKDB command.<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Run standard scan to repair the selected database file quickly.<\/li>\n<\/ul><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"510\" height=\"210\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/select-scan-mode-image.png\" alt=\"select scan mode\" class=\"wp-image-85955 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/select-scan-mode-image.png 510w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/select-scan-mode-image-300x124.png 300w\" sizes=\"auto, (max-width: 510px) 100vw, 510px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Preview the repairable database objects and select all or specific objects you want to restore. Next, press the <strong>Save<\/strong> button from the <strong>File<\/strong> menu.<\/li>\n<\/ul><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"836\" height=\"716\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/repaired-database-file-preview-image.png\" alt=\"repaired database file preview\" class=\"wp-image-85956 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/repaired-database-file-preview-image.png 836w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/repaired-database-file-preview-image-300x257.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/repaired-database-file-preview-image-768x658.png 768w\" sizes=\"auto, (max-width: 836px) 100vw, 836px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Enter the details as shown in the following screen to complete the file saving process.<\/li>\n<\/ul><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"344\" height=\"288\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/repaired-file-saving-options-image.png\" alt=\"repaired file saving options\" class=\"wp-image-85957 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/repaired-file-saving-options-image.png 344w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2021\/08\/repaired-file-saving-options-image-300x251.png 300w\" sizes=\"auto, (max-width: 344px) 100vw, 344px\" \/><\/figure><p>Once the software repairs the .MDF file, you will no longer see the SQL Server error 823.<\/p><h2 class=\"wp-block-heading\" id=\"conclusion\"><strong>Conclusion<\/strong><\/h2><p>This blog discussed the reasons that could result in SQL Server database error 823. It can be caused by hardware (disk errors, hardware or software failures) or system problems. Also, the blog explained how to fix the SQL 823 error by restoring the database from backup, running DBCC CHECKDB with a repair option, or using&nbsp;<strong>Stellar Repair for MS SQL<\/strong> software. Stellar Repair for MS SQL is a simple SQL repair tool. If you have any queries, please do not hesitate to write your questions and comments.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What is&nbsp;SQL error 823? A SQL Server database encounters error 823 when&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/\">Continue reading <span class=\"screen-reader-text\">How to Fix SQL Server Database Fatal Error 823?<\/span><\/a><\/p>\n","protected":false},"author":15,"featured_media":15963,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10],"tags":[754],"class_list":["post-15925","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-recovery","tag-sql-server-error-823","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Fix SQL Server Database Fatal Error 823?<\/title>\n<meta name=\"description\" content=\"SQL server database error 823 is logical consistency-based IO error which is easy to repairable by these simple solutions. Read the blog and fix the fatal error.\" \/>\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.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Fix SQL Server Database Fatal Error 823?\" \/>\n<meta property=\"og:description\" content=\"SQL server database error 823 is logical consistency-based IO error which is easy to repairable by these simple solutions. Read the blog and fix the fatal error.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-12T11:24:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-22T06:38:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/How-to-solve-the-SQL-Server-error-823-logical-consistency-based-IO-error.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Priyanka Chauhan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@priyanka66\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Chauhan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/\"},\"author\":{\"name\":\"Priyanka Chauhan\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470\"},\"headline\":\"How to Fix SQL Server Database Fatal Error 823?\",\"datePublished\":\"2018-02-12T11:24:13+00:00\",\"dateModified\":\"2025-08-22T06:38:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/\"},\"wordCount\":1058,\"commentCount\":10,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/How-to-solve-the-SQL-Server-error-823-logical-consistency-based-IO-error.jpg\",\"keywords\":[\"SQL Server error 823\"],\"articleSection\":[\"SQL Database Repair\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/\",\"name\":\"How to Fix SQL Server Database Fatal Error 823?\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/How-to-solve-the-SQL-Server-error-823-logical-consistency-based-IO-error.jpg\",\"datePublished\":\"2018-02-12T11:24:13+00:00\",\"dateModified\":\"2025-08-22T06:38:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470\"},\"description\":\"SQL server database error 823 is logical consistency-based IO error which is easy to repairable by these simple solutions. Read the blog and fix the fatal error.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/How-to-solve-the-SQL-Server-error-823-logical-consistency-based-IO-error.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/How-to-solve-the-SQL-Server-error-823-logical-consistency-based-IO-error.jpg\",\"width\":1000,\"height\":600,\"caption\":\"SQL Server Error 823\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Fix SQL Server Database Fatal Error 823?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/\",\"name\":\"Stellar Data Recovery Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470\",\"name\":\"Priyanka Chauhan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g\",\"caption\":\"Priyanka Chauhan\"},\"description\":\"Priyanka is a technology expert working for key technology domains that revolve around Data Recovery and related software's. She got expertise on related subjects like SQL Database, Access Database, QuickBooks, and Microsoft Excel. Loves to write on different technology and data recovery subjects on regular basis. Technology freak who always found exploring neo-tech subjects, when not writing, research is something that keeps her going in life.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/priyankachouhan\/\",\"https:\/\/x.com\/priyanka66\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/priyanka\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Fix SQL Server Database Fatal Error 823?","description":"SQL server database error 823 is logical consistency-based IO error which is easy to repairable by these simple solutions. Read the blog and fix the fatal error.","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.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/","og_locale":"en_US","og_type":"article","og_title":"How to Fix SQL Server Database Fatal Error 823?","og_description":"SQL server database error 823 is logical consistency-based IO error which is easy to repairable by these simple solutions. Read the blog and fix the fatal error.","og_url":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2018-02-12T11:24:13+00:00","article_modified_time":"2025-08-22T06:38:16+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/How-to-solve-the-SQL-Server-error-823-logical-consistency-based-IO-error.jpg","type":"image\/jpeg"}],"author":"Priyanka Chauhan","twitter_card":"summary_large_image","twitter_creator":"@priyanka66","twitter_misc":{"Written by":"Priyanka Chauhan","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/"},"author":{"name":"Priyanka Chauhan","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470"},"headline":"How to Fix SQL Server Database Fatal Error 823?","datePublished":"2018-02-12T11:24:13+00:00","dateModified":"2025-08-22T06:38:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/"},"wordCount":1058,"commentCount":10,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/How-to-solve-the-SQL-Server-error-823-logical-consistency-based-IO-error.jpg","keywords":["SQL Server error 823"],"articleSection":["SQL Database Repair"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/","url":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/","name":"How to Fix SQL Server Database Fatal Error 823?","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/How-to-solve-the-SQL-Server-error-823-logical-consistency-based-IO-error.jpg","datePublished":"2018-02-12T11:24:13+00:00","dateModified":"2025-08-22T06:38:16+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470"},"description":"SQL server database error 823 is logical consistency-based IO error which is easy to repairable by these simple solutions. Read the blog and fix the fatal error.","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/How-to-solve-the-SQL-Server-error-823-logical-consistency-based-IO-error.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2018\/02\/How-to-solve-the-SQL-Server-error-823-logical-consistency-based-IO-error.jpg","width":1000,"height":600,"caption":"SQL Server Error 823"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/how-to-fix-sql-server-error-823\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Fix SQL Server Database Fatal Error 823?"}]},{"@type":"WebSite","@id":"https:\/\/www.stellarinfo.com\/blog\/#website","url":"https:\/\/www.stellarinfo.com\/blog\/","name":"Stellar Data Recovery Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/94fe9ee94eb813d94397deee2b641470","name":"Priyanka Chauhan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/65b92f324507fb182b01aa142f74fb8925fc3c0bcc38f74bd17d59c4a53afd96?s=96&d=mm&r=g","caption":"Priyanka Chauhan"},"description":"Priyanka is a technology expert working for key technology domains that revolve around Data Recovery and related software's. She got expertise on related subjects like SQL Database, Access Database, QuickBooks, and Microsoft Excel. Loves to write on different technology and data recovery subjects on regular basis. Technology freak who always found exploring neo-tech subjects, when not writing, research is something that keeps her going in life.","sameAs":["https:\/\/www.linkedin.com\/in\/priyankachouhan\/","https:\/\/x.com\/priyanka66"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/priyanka\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/15925","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=15925"}],"version-history":[{"count":75,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/15925\/revisions"}],"predecessor-version":[{"id":185162,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/15925\/revisions\/185162"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/15963"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=15925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=15925"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=15925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}