Sunday, August 9, 2009

Error 3403 in SQL Server

A SQL Server database is comprised of two basic components, viz. data files and transaction logs. A transaction log file is the one which records uncommitted transactions of database. If due to any reason, SQL Server service shuts down unexpectedly, the next time when you restart the server, it analyzes all the transaction log files and if not committed, it rolls back all the changes that have been performed as the part of such transactions. But sometimes, this recovery procedure fails to end successfully and database remains in corrupted state. Such situations require you to restore from the last good backup. However, if no backup is available or is damaged, you should use SQL Repair applications.

You might encounter the below error message with your SQL Server database:

Error 3403, Severity 22
During recovery initialization, page %ld was encountered. This page belongs to object %ld, not the log

Cause

After the SQL crash, SQL Server automatically tries to recover. While it occurs, it scans the complete transaction log till the last page. If it finds a page, which is allocated to syslogs but the object ID on the page header doesn’t match with that of syslogs, it displays error 3403 and recovery fails. It occurs because of following possible reasons:

A SQL Server problem resulted in a bad write or page allocation
Allocation page was updated and SQL Server went down before the transaction log page could be written. So, when later SQL database rebuilt itself, it did it without transaction log pages being cleared, while the old log entries still exist.

Solution

To solve such issues, you should apply these methods:

Check your backup status. If a clean backup exists, drop the damaged database and load it from the backup
If no valid backup exists, use commercial SQL Server Recovery applications to repair and restore the database

SQL Repair software are powerful and safe tools that use efficient scanning algorithms to repair a damaged SQL Server database. Such applications feature thorough file scanning, non-destructive design, graphically rich user interface and complete documentation.

Stellar Phoenix SQL Database Recovery is the finest SQL Recovery application that supports SQL Server 2008, 2005 and 2000. 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 non-destructive tool with intuitive interface.

No comments:

Post a Comment