How to Perform SQL Database Recovery after Receiving Message 7105 in MS SQL Server 2005

Large Object (LOB) data are always difficult to deal with in an SQL Server database. Several problems are faced by the database users while trying to load, store, or retrieve these Large Object data types. It is always a tough task to optimize your database performance when using the LOB data fields. They are usually stored on separate database pages and only a pointer to them is stored in the corresponding table row. Sometimes, due to corruption in LOB page structures, a query may not be able to access the LOB data. At this stage,
you may receive some error messages on your screen. It may also render your database corrupt. To overcome any such situation, you need to go for SQL recovery through any third party utility.

A query may result in the following error message while trying to access a database page containing LOB data:

“Msg 7105, Level 22, State 6, Line 1
The Database ID 11, Page (255:177), slot 1 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE”

This may make your database corrupt and thus, inaccessible. To have an access your database again, you need to perform SQL repair of your corrupt database.

The error may have occurred due to any of the following reasons:
• The LOB page structures that the query references are corrupt.
• The query that has resulted in this error may be using READ UNCOMMITTED ISOLATION LEVEL or the NOLOCK query hint.
• SQL Server engine may have encountered a problem.

You should run DBCC CHECKDB command on your database and follow the recommendations to repair and restore the corrupt database. Some data loss may occur while using this command. In this situation, you can perform SQL recovery of your database through a backup. If the backup is missing, follow the below mentioned resolution steps.

To fix the issue, obtain the latest update for SQL Server 2005 Service Pack 3.
However, if you are unable to install the update for SQL Server, you should use a reliable SQL Database Recovery software to recover back the lost data from your corrupt SQL database. These software are capable of repairing any corrupt database file by performing a selective recovery of all the database objects including tables, views, constraints, keys, rules etc.


Post a Comment

All about Technology