Wednesday, August 26, 2009

How to Resolve Error 2503 in SQL Server?

In SQL Server storage space is divided into pages, numbered sequentially. Each database page has a type that defines the type of data that is contained in the page, for example an index page or a data page. If any of these pages gets corrupt, SQL Server reports errors. You can detect this corruption by running DBCC CHECKDB command. However, to recover from such data loss, you will need to use your backup to restore. But if no clean backup is available at the moment, you should use SQL Recovery software.

At times, when you run DBCC command to check the consistency of your SQL Server database, you might come across the below error :

“Msg 2503, Level 16, State 1 Table Corrupt: Page linkage is not consistent; check the following pages: current page#=xxx; page# pointing to this page=yyyy; previous page#=zzzz”

Cause

Error 2503 might be encountered due to any of the possible reasons:

You are not running DBCC in single-user mode and some updates are running
Table data page or index page is corrupt

Solution

To solve the problem, discussed above, you need to apply these methods:

Make sure that you run DBCC in single-user mode
If you are using the command in single-user mode, you need to check for a valid data backup to restore the lost data
If you don't have any good data backup, use DBCC PAGE command to find out whether the infected page is a data page or an index page
To fix index corruption, you should drop and then recreate the index of the table
You need to copy all the database objects and data to a new database if the data pages are affected. You might fail to copy corrupted tables. Drop the old database
If applying the above measures doesn't help, you should use third-party SQL Repair utility to safely repair and restore the damaged database and its objects. SQL Recovery software apply powerful scanning algorithms and retreive data while maintaining their intactness.

Stellar Phoenix SQL Recovery is an advanced utility to repair damaged SQL databases. It supports SQL Server 2008, 2005 and 2000. With self-descriptive and exceptionally realistic interface, advanced repair options and non-destructive design, it is an effective SQL Repair tool to repair all database objects. The software is compatible with Windows Vista, XP, 2003, 2000 and NT.

No comments:

Post a Comment