Friday, July 17, 2009

Fixing Error 8909 in SQL Database

The DBCC DBREINDEX is a Transactional-SQL command that rebuilds one or more indexes for a table in the SQL database. The DBCC SHRINKDATABASE is a T-SQL command which shrinks the size of the data and log files in the specified database. If these commands are executed concurrently on a particular table, the table is corrupted. In such situations, if the user has not created any back up, he can recover the table by using effective SQL Recovery software.

For example, when a user executes DBCC DBREINDEX concurrently with DBCC SHRINKDATABASE on a table, he encounters the below error message:

“Error: 8909

Table Corrupt: Object ID 0, index ID 0, page ID (1:623). Page Id in the page header = (0:0).”

The above error message halts the shrink operation and makes the table corrupt. The main cause of the above error message is that the user executes the shrink database and re-indexing operations at the same time. This error message mainly appears in multiprocessor environments. To prevent your SQL components from the above problem, the user needs to reschedule the operations to run at different times and turn off the Auto shrink option. To resolve the above error the user needs to execute DBCC CHECKDB command with repair_allow_data_loss option. This command reports the user that the error has been fixed although the error is not fixed. To resolve the error and access the table, the user needs to restore the table from the recent back up. But if the user has not maintained any back up, then he needs to use efficient SQL Recovery software.

Stellar Phoenix SQL recovery software, provided by Stellar Information Systems Limited ensures complete SQL Database Recovery. This application can Repair SQL components like tables, queries, views, triggers and stored procedures by incorporating influential scanning methods. It is read only application that provides safe and non-destructive sql database recovery. This SQL Repair application provides highly interactive and intuitive user interface that makes it easy to understand and implement.

This SQL Repair application can also recover and restore the backup files of MS SQL Server. It supports MS SQL Server 2005 and MS SQL Server 2000. It supports Windows Vista, XP, 2003 and 2000.The demo version of this SQL Repair utility is available on Stellar’ s website and popular shareware websites, which allows the user to preview the lost SQL database components, which the user can recover.

No comments:

Post a Comment