{"id":133,"date":"2012-08-21T12:09:00","date_gmt":"2012-08-21T12:09:00","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=133"},"modified":"2013-12-28T09:24:26","modified_gmt":"2013-12-28T09:24:26","slug":"sql-server-detected-a-logical-consistency-based-io-error-incorrect-checksum","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/sql-server-detected-a-logical-consistency-based-io-error-incorrect-checksum\/","title":{"rendered":"SQL Server detected a logical consistency-based I\/O error: Incorrect checksum. It occurred during a read of page. This is a sever error condition that threatens database integrity and must be corrected immediately."},"content":{"rendered":"<p><strong>Error:<\/strong><\/p>\n<p>SQL Server detected a logical consistency-based I\/O error: Incorrect checksum. It occurred during a read of page. This is a sever error condition that threatens database integrity and must be corrected immediately.<\/p>\n<p><strong>Error Message:<\/strong><\/p>\n<p><a href=\"http:\/\/techsupport.relyonsoft.in\/wp-content\/uploads\/2012\/08\/RestoreError.jpg\"><img loading=\"lazy\" class=\"alignnone size-full wp-image-832\" title=\"RestoreError\" src=\"http:\/\/techsupport.relyonsoft.in\/wp-content\/uploads\/2012\/08\/RestoreError.jpg\" alt=\"\" width=\"639\" height=\"393\" srcset=\"https:\/\/relyonsoft.in\/techsupport\/wp-content\/uploads\/2012\/08\/RestoreError.jpg 639w, https:\/\/relyonsoft.in\/techsupport\/wp-content\/uploads\/2012\/08\/RestoreError-300x184.jpg 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/a><\/p>\n<p><strong>Causes:<\/strong><\/p>\n<p>There are multiple reasons for database suspect status.<\/p>\n<p>1. Backup files corruption<\/p>\n<p>2. Network break (if you are restoring from remote path)<\/p>\n<p>3. Low disk space in destination.<\/p>\n<p><strong>Workarournd 1:<\/strong><\/p>\n<p>Execute the following Query to repair against the database<\/p>\n<p>EXEC sp_resetstatus &lt;Database-Name&gt;<\/p>\n<p>ALTER DATABASE &lt;Database-Name&gt; SET EMERGENCY<\/p>\n<p>DBCC CHECKDB &lt;Database-Name&gt;<\/p>\n<p>ALTER DATABASE &lt;Database-Name&gt; SET SINGLE_USER WITH ROLLBACK IMMEDIATE<\/p>\n<p>DBCC CHECKDB (&lt;Database-Name&gt;, REPAIR_ALLOW_DATA_LOSS)<\/p>\n<p>ALTER DATABASE &lt;Database-Name&gt; SET MULTI_USER<\/p>\n<p>USE &lt;Database-Name&gt;<\/p>\n<p><strong>Workarournd 2:<\/strong><\/p>\n<p>Backup file may be corrupted. Not able to read the data. Try from different backup file.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error: SQL Server detected a logical consistency-based I\/O error: Incorrect checksum. It occurred during a read of page. This is a sever error condition that threatens database integrity and must be corrected immediately. Error Message: Causes: There are multiple reasons for database suspect status. 1. Backup files corruption 2. Network break (if you are restoring [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/133"}],"collection":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":0,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/133\/revisions"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}