Error 2535 and 8928 in SQL Server - By: Addison Philip

SQL Server is Microsoft provided relational model database server. In addition to relational data, it also natively supports managing XML data. SQL Server is available in different versions that vary in terms of features and targeting users. But sometimes, you find issues while accessing its database contents. Such problems are more frequent in database tables when you try to run queries. It generally indicates table corruption. Tables are database components that store data. So, to restore lost information in this way, you need to use your recent backup. However, if backup is damaged, absent or not updated, mdf repair tools can serve the purpose of database repair and restoration.

As a practical instance, when you try to run a SQL query on a table, you receive the following error message:

“Attempt to fetch logical page (1:42724) in database belongs to object , not to object 'RRR'.Connection Broken..”

Further, when you run DBCC CHECKTABLE command with REPAIR_ REBUILD option, you encounter different error messages, similar to:

Server: Msg 2535, Level 16, State 1, Line 1
Table Corrupt: Page (1:42724) is allocated to object ID 1517248460, index ID 0, not to object ID 982294559, index ID 0 found in page header.

Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1517248460, index ID 0: Page (1:42723) could not be processed. See other errors for details.

Cause

The above behavior occurs due to SQL database corruption inconsistencies, generally due to index corruption.

Solution

To resolve the above issues, you need to follow these steps:

. Ensure that the database is online
. Next, try rebuilding the database indexes using DBCC DBREINDEX command
. If problem persists, you require repairing the database using DBCC CHECKDB with the REPAIR_ALLOW_DATA_LOSS option. But the use of command forces some data to be lost.
. Perform safe MDF Recovery using read-only SQL database repair tools. These are graphically rich and read-only tools that scan your damaged SQL databases using powerful scanning algorithms. MDF Repair applications are available with advanced repair options, to the point documentation, and complete database recovery abilities.

Stellar Phoenix SQL Database Recovery is the finest repair mdf file application. It supports SQL Server 2000 and 2005. It can restore all database objects, including tables, views, stored procedures, rules, defaults, user defined data types and triggers. The software is compatible with Windows Vista, XP, 2003, 2000 and NT. It is a read-only tool with intuitive interface.

About the Author

Addison Philip work as a freelancer and researcher of repair sql & ms sql recovery software.

Article Directory Source: http://www.articlerich.com/profile/Addison-Philip/52775

Additional Articles From - Home | Computers | Data recovery