How To Fix “Error: 823” In Microsoft SQL Server Article

	1888 Articles Home \| Computer Articles \| Data Recovery Articles \| Windows Articles	Data Recovery RSS
How to Fix “Error: 823” in Microsoft SQL Server

Are you getting system-level errors while accessing your Microsoft SQL Server database? Are you unable to perform any I/O (Input/Output) operation on your database?

Author: Mark Willium

Article Tools:

Well, the problem generally occurs due to either conflicts of Windows API used by SQL Server or SQL Server database corruption. It leaves your database in an unusable state and leads to severe data loss situations. In order to get your mission critical data back in such cases, you must go for SQL database recovery solutions.

For instance, you may run across an error message similar to the following one in Windows Application Event Log or Microsoft SQL Server ERRORLOG:

“2010-03-06 22:41:19.55 spid58 Error: 823, Severity: 24, State: 2.
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 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\my_db.mdf'. 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. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.”

When a program encounters the above error message while modifying or querying the data, error is returned to that program and SQL Server database connected is closed.

Root of the problem:

The problem is caused by Windows APIs, used by Microsoft SQL Server. These APIs (such as WriteFile, ReadFile, WriteFileGather, and ReadFileScatter) are used to perform Input/Output operations. Upon completion of I/O operations, MS SQL Server examines for errors associated with API calls. When API calls betrays with OS error, you come across this behavior of SQL Server. The problem may also occur due to severe corruption to Microsoft SQL Server database.

Solution:

Go through the below steps to recover SQL server database from corruption:
Review suspect pages table.

Check database consistency.

Review Windows Application Event Log to find operating system and file system related errors.

Restore database from current backup.

If the above methods fail to perform SQL Server recovery, you are required to opt for advanced third-party applications.

The MS SQL recovery applications ensure absolute recovery by throughly scanning the database using advanced scanning algorithms. They offer easy and safe recovery with simple user interface and non-destructive behavior.

Stellar Phoenix SQL Recovery is the most efficient and result-oriented utility to offer assured recovery of corrupted database. This software is designed to restore corrupt databases of MS SQL Server 2008, 2005, 2000, and 7.0. It retrieves tables, reports, macros, forms, triggers, stored procedures, constraints, default constraints, and other MS SQL Server database objects.

About Author

My name is Mark Willium, I have done Ph.D in computer science and currently doing research on how to recover and repair corrupted sql database. During research found many repair & recovery software for SQL database, some of them are ms sql repair, sql recovery, ms sql database recovery, recover sql, repair mdf file and many more. Click this for details: http://www.mssqldatabaserecovery.com/sqlserver-mdf-file-recovery.php

Article Source: http://www.1888articles.com/author-mark-willium-32501.html

How to Fix “Error: 823” in Microsoft SQL Server