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.
Wednesday, August 26, 2009
Monday, August 24, 2009
How to Troubleshoot SQL Server Error 8910?
An SQL Server database is divided into pages each of 8 KB in size. An IAM (Index Allocation Map) page is the one that holds information about table extents or index information for each allocation unit. The page contains the location information of first 8 pages and also bitmap of extents for used extents. These are mixed pages but do not reference themselves. Among other things, an IAM page contains a mixed page array, which is actually an array of eight page IDs that holds mixed pages that have been allocated to the index. An SQL Server database might sometimes report corruption errors in these IAM pages. To restore lost information in such way, you will need to either use your recent database backup or use SQL Recovery tools to scan and repair the corrupted database.
For an example, you might come across the below error with your SQL Server database
“Server: Msg 8910, Level 16, State ST_NO Line L_NO
Page P_ID in database ID DB_ID is allocated to both object ID O_ID1, index ID I_ID1, and object ID O_ID2, index ID I_ID2.”
Where, ST_NO is the state of error message and can be either '1' or '2'.
Cause
If you receive the above error with state '1', this implies there exist two indexes that have their page allocated in either of mixed page array of IAM page. However, if you are getting this error with state '2' the reason could be that there exists a page that has been entered twice in mixed page array of an IAM page. These typically represent database in inconsistent state.
Solution
Follow these measures to solve the given problem:
Restore from backup if available and exists in valid state for complete restoration
Execute DBCC CHECKDB. Doing so will let your know the exact repair clause that should be applied to repair the database. Again, run DBCC CHECKDB with this clause.
Applying the above step might cause some data to be deleted. To prevent this, use safe SQL Repair tools that are competent to repair corrupted SQL Server database in any set of conditions. SQL Recovery software provide easy repair options through interactive interface and comprehensive recovery results.
SQL Recovery is an advanced SQL Server Recovery tool for damaged SQL Server databases. It supports repair for SQL Server 2008, 2005 and 2000. The software is available with self-descriptive interface and restores all database objects including tables, user defined data types and functions, triggers, stored procedures, views, rules etc. The software is compatible with Windows Vista, XP, 2003, 2000, and NT.
For an example, you might come across the below error with your SQL Server database
“Server: Msg 8910, Level 16, State ST_NO Line L_NO
Page P_ID in database ID DB_ID is allocated to both object ID O_ID1, index ID I_ID1, and object ID O_ID2, index ID I_ID2.”
Where, ST_NO is the state of error message and can be either '1' or '2'.
Cause
If you receive the above error with state '1', this implies there exist two indexes that have their page allocated in either of mixed page array of IAM page. However, if you are getting this error with state '2' the reason could be that there exists a page that has been entered twice in mixed page array of an IAM page. These typically represent database in inconsistent state.
Solution
Follow these measures to solve the given problem:
Restore from backup if available and exists in valid state for complete restoration
Execute DBCC CHECKDB. Doing so will let your know the exact repair clause that should be applied to repair the database. Again, run DBCC CHECKDB with this clause.
Applying the above step might cause some data to be deleted. To prevent this, use safe SQL Repair tools that are competent to repair corrupted SQL Server database in any set of conditions. SQL Recovery software provide easy repair options through interactive interface and comprehensive recovery results.
SQL Recovery is an advanced SQL Server Recovery tool for damaged SQL Server databases. It supports repair for SQL Server 2008, 2005 and 2000. The software is available with self-descriptive interface and restores all database objects including tables, user defined data types and functions, triggers, stored procedures, views, rules etc. The software is compatible with Windows Vista, XP, 2003, 2000, and NT.
Thursday, August 20, 2009
Resolving SQL Table Error: Cross Object Linkage
SQL Server uses index information so that if you process a query that could fetch quick results. These are created on table columns. An index is basically comprised of various pages, arranged in the form of a B-tree structure. So, as you execute a query, the engine starts navigating from the root node and continue through the intermediate nodes till the leaf node is reached. Any malfunction in this index structure might introduce table corruption errors. Such situations require you to restore the data from backup or use SQL Repair utilities that could repair the database and its components effectively.
You might encounter the below table error with your SQL Server database:
“Table error: Cross object linkage. Page P_ID1->next in object ID O_ID1, index ID I_ID1 refers to page P_ID2 in object ID O_ID2, index ID I_ID2 but is not in the same index.”
This error is marked as error 8982 in SQL Server error log with severity level 16.
Cause
An SQL Server table results the above error if the two pages (P_ID1 and P_ID2) have been marked with dissimilar index and/or object information though they have been marked as linked.
Note: If you observe these problems persistently occurring, the possible reason is hardware malfunction.
Solution
Such table corruption errors should be resolved by following these methods:
First, you need to analyze your system for possible hardware problems. You can deduce such problems through error logs of operating system, application and SQL Server™ . Try to fix such problems, if any.
If you have valid data backup available, you need to restore your lost data from it.
If issue persists because of unavailability of clean data backup, you can run DBCC CHECKDB command that will let you know the exact repair clause that could fix this corruption. Execute DBCC CHECKDB command using the recommended repair clause.
Applying the above measure can cause data loss. Thus, for better and safe SQL Recovery, you should use third-party tools to scrutinize and repair damaged SQL Server databases. SQL Repair applications are built with powerful technology to assist database recovery in each possible case of corruption.
SQL Recovery is a comprehensive tool to repair damaged SQL databases for SQL Server 2008, 2005 and 2000. With self-descriptive interface, advanced repair options and read-only design, it is an effective SQL Repair tool to repair and restore all database objects. The software is compatible with Windows Vista, XP, 2003, 2000 and NT.
You might encounter the below table error with your SQL Server database:
“Table error: Cross object linkage. Page P_ID1->next in object ID O_ID1, index ID I_ID1 refers to page P_ID2 in object ID O_ID2, index ID I_ID2 but is not in the same index.”
This error is marked as error 8982 in SQL Server error log with severity level 16.
Cause
An SQL Server table results the above error if the two pages (P_ID1 and P_ID2) have been marked with dissimilar index and/or object information though they have been marked as linked.
Note: If you observe these problems persistently occurring, the possible reason is hardware malfunction.
Solution
Such table corruption errors should be resolved by following these methods:
First, you need to analyze your system for possible hardware problems. You can deduce such problems through error logs of operating system, application and SQL Server™ . Try to fix such problems, if any.
If you have valid data backup available, you need to restore your lost data from it.
If issue persists because of unavailability of clean data backup, you can run DBCC CHECKDB command that will let you know the exact repair clause that could fix this corruption. Execute DBCC CHECKDB command using the recommended repair clause.
Applying the above measure can cause data loss. Thus, for better and safe SQL Recovery, you should use third-party tools to scrutinize and repair damaged SQL Server databases. SQL Repair applications are built with powerful technology to assist database recovery in each possible case of corruption.
SQL Recovery is a comprehensive tool to repair damaged SQL databases for SQL Server 2008, 2005 and 2000. With self-descriptive interface, advanced repair options and read-only design, it is an effective SQL Repair tool to repair and restore all database objects. The software is compatible with Windows Vista, XP, 2003, 2000 and NT.
Tuesday, August 18, 2009
Resolving SQL Server Error 8942
A SQL Server database table is prone to corruption due to unexpected shutdown, application errors, hardware bugs and similar other faults, thereby resulting into DBCC CHECKDB errors or inaccessible table. To resolve such issues, it becomes essential that you restore from the latest database backup. But sometimes, it is not feasible to restore complete information from the backup. Thus, you should use SQL recovery tools to repair these databases.
As an instance, you might encounter the below error with SQL Server table:
Server: Msg 8942, Level 16, State 1
Table error: Object ID O_ID, index ID I_ID, page P_ID. Test (TEST) failed. Slot S_ID, offset 0xADDRESS overlaps with the prior row.
Cause
The above error occurs due to overlapping of slots. It primarily occurs when the offset of slot S_ID is not equal or greater to previous slot end. The error is the result of a table test, in which sorted[i].offset has not been found greater or equal to a expected value, 'max'. Here, 'max' signifies the end of last slot and [i] is the ADDRESS.
Solution
To troubleshoot these database table errors, you are recommended to consider these methods:
If you are encountering such problems repeatedly, it might be due to hardware issues. So, you need to diagnose the system, application and SQL Server™ error log to know the exact hardware issues, if any. Remove, swap and replace the damaged hardware
If this is not a known hardware problem, restore the database from the recent data backup
In cases, when you don't have any valid data backup, you need to run DBCC CHECKDB command without using any repair clause. This will allow you to determine the exact repair clause required to be applied for database repair. Next, run DBCC CHECKDB with this repair clause.
Applying the above measure can cause data loss. To perform safe database repair, you should use SQL Repair software. These are perfect tools that apply safe scanning algorithms to result effective repair of complete database and its components. SQL Recovery tools are highly competent utilities with graphically rich user interface.
Stellar Phoenix SQL Recovery is a comprehensive SQL Repair utility to repair damaged databases created with SQL Server 2008, 2005 and 2000. It is a fully-competent tool that restores all database components including triggers, stored procedures, views, rules and more. The software is compatible with Windows Vista, XP, 2003, 2000 and NT.
As an instance, you might encounter the below error with SQL Server table:
Server: Msg 8942, Level 16, State 1
Table error: Object ID O_ID, index ID I_ID, page P_ID. Test (TEST) failed. Slot S_ID, offset 0xADDRESS overlaps with the prior row.
Cause
The above error occurs due to overlapping of slots. It primarily occurs when the offset of slot S_ID is not equal or greater to previous slot end. The error is the result of a table test, in which sorted[i].offset has not been found greater or equal to a expected value, 'max'. Here, 'max' signifies the end of last slot and [i] is the ADDRESS.
Solution
To troubleshoot these database table errors, you are recommended to consider these methods:
If you are encountering such problems repeatedly, it might be due to hardware issues. So, you need to diagnose the system, application and SQL Server™ error log to know the exact hardware issues, if any. Remove, swap and replace the damaged hardware
If this is not a known hardware problem, restore the database from the recent data backup
In cases, when you don't have any valid data backup, you need to run DBCC CHECKDB command without using any repair clause. This will allow you to determine the exact repair clause required to be applied for database repair. Next, run DBCC CHECKDB with this repair clause.
Applying the above measure can cause data loss. To perform safe database repair, you should use SQL Repair software. These are perfect tools that apply safe scanning algorithms to result effective repair of complete database and its components. SQL Recovery tools are highly competent utilities with graphically rich user interface.
Stellar Phoenix SQL Recovery is a comprehensive SQL Repair utility to repair damaged databases created with SQL Server 2008, 2005 and 2000. It is a fully-competent tool that restores all database components including triggers, stored procedures, views, rules and more. The software is compatible with Windows Vista, XP, 2003, 2000 and NT.
Monday, August 17, 2009
Resolving SQL Page with Incorrect Type Error
All the SQL database files are split into PFS intervals, where PFS stands for Page Free Space. A PFS interval is about 64 MB in size and has 8088 pages in it. Each PFS page has a byte-map with one byte per page for all the pages included in the PFS interval. At times, you get database errors that indicate that a page exists with invalid type in its PFS page. Database corrupted in this way needs to be restored from backup. However, if you don't have any valid data backup available, you need to use advanced SQL Recovery application.
For an instance, you might come across the similar error message with your SQL Server database:
“Database error: Page P_ID1 is marked with the wrong type in PFS page P_ID2. PFS status 0xVAL1 expected 0xVAL2.”
This error is marked as error 8948 in SQL Server error log.
Cause
The above error results when a page P_ID1 has been marked with incorrect type entry in PFS page P_ID2. As described above, each PFS page has a byte-map with one byte per page for all the pages included in the PFS interval. Among rest of the information, each byte contains three specific type of status bits that define the page type:
(0x10) for PFS_IS_IAM_PG
(0x40) for PFS_IS_ALLOCATED
(0x20)for PFS_IS_MIXED_EXT
Error 8948 occurs when these bits are improperly set.
Solution
You need to deploy these measures to cope up with such issues:
If such kind of problems are persistent in nature, you should check the system for possible hardware problems first. You can do so by examining the error log reports of Windows, SQL Server™ and application.
Check the database backup status. If complete and valid, delete the damaged database and restore from the backup.
Without using any repair clause, execute DBCC CHECKDB to determine the required repair clause to be applied. Next, run DBCC CHECKDB with this repair clause.
If you desire to prevent data loss that might occur due to the above step, you need to use advanced SQL Repair tools. These are safe SQL Recovery software that can scan a corrupted database and restore it successfully.
Stellar Phoenix SQL Recovery is a premier tool to repair damaged SQL databases and is supportive to 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.
For an instance, you might come across the similar error message with your SQL Server database:
“Database error: Page P_ID1 is marked with the wrong type in PFS page P_ID2. PFS status 0xVAL1 expected 0xVAL2.”
This error is marked as error 8948 in SQL Server error log.
Cause
The above error results when a page P_ID1 has been marked with incorrect type entry in PFS page P_ID2. As described above, each PFS page has a byte-map with one byte per page for all the pages included in the PFS interval. Among rest of the information, each byte contains three specific type of status bits that define the page type:
(0x10) for PFS_IS_IAM_PG
(0x40) for PFS_IS_ALLOCATED
(0x20)for PFS_IS_MIXED_EXT
Error 8948 occurs when these bits are improperly set.
Solution
You need to deploy these measures to cope up with such issues:
If such kind of problems are persistent in nature, you should check the system for possible hardware problems first. You can do so by examining the error log reports of Windows, SQL Server™ and application.
Check the database backup status. If complete and valid, delete the damaged database and restore from the backup.
Without using any repair clause, execute DBCC CHECKDB to determine the required repair clause to be applied. Next, run DBCC CHECKDB with this repair clause.
If you desire to prevent data loss that might occur due to the above step, you need to use advanced SQL Repair tools. These are safe SQL Recovery software that can scan a corrupted database and restore it successfully.
Stellar Phoenix SQL Recovery is a premier tool to repair damaged SQL databases and is supportive to 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.
Sunday, August 16, 2009
Error 2570 in SQL Server
SQL Server includes a database check utility called DBCC CHECKDB. In SQL Server 2005, you can use this command with DATA_PURITY option enabled that allows you to perform ‘data purity’ validations on each column value in all rows of a table or multiple tables from the database. If you run this check and it outputs error messages that indicates problems with data and hence database integrity. In such situations, you need to use your recent backup to restore the lost information. But, if you find it invalid or inappropriate to deliver required results, SQL Server Recovery tools can be used as a solution.
Consider a scenario, you check your database integrity using DBCC CHECKDB with DATA_PURITY option enabled and it gives the below error message:
“Msg 2570, Level 16, State 2, Line 1
Page %S_PGID, slot %d in Object %d Index %d Column %.*ls value %.*ls is out of range for data type "%.*ls". Update column to a legal value.”
This error message occurs for every row that contains an invalid column value.
Cause
The above error occurs due to invalid data in a column of a table as invalid floating point values as SNAN, QNAN, NINF, ND, PD, PINF etc. It can also happen due to out-of-range data or hardware issues.
Solution
To correct the above issue, you need to follow any of the below methods:
You should find the affected rows and manually update them with correct values. To do this, you can execute T-SQL (Transact-SQL) queries against the table or alternatively, refer to the information provided by error 2570. You can set it to any of acceptable default or specific value.
Note: You can’t run DBCC command to repair the database as it can’t determine
the value to be placed instead of invalid column value.
In case if affected rows are large in number and it is not possible to update them manually, you can restore them from backup
If the above measure is not feasible because of backup unavailability or corruption, you need to use MDF Recovery applications to safely repair and restore your database. Such MDF Repair software use powerful scanning algorithms and offer advanced repair and restoration options together with interactive user interface.
Stellar Phoenix SQL Recovery is the foremost SQL Repair tool to repair damaged SQL databases. With self-descriptive interface, advanced repair options and read-only nature, it is an effective tool to repair all database objects. It supports SQL Server 2005 and SQL Server 2000. The software is compatible with Windows Vista, XP, 2003, 2000 and NT.
Consider a scenario, you check your database integrity using DBCC CHECKDB with DATA_PURITY option enabled and it gives the below error message:
“Msg 2570, Level 16, State 2, Line 1
Page %S_PGID, slot %d in Object %d Index %d Column %.*ls value %.*ls is out of range for data type "%.*ls". Update column to a legal value.”
This error message occurs for every row that contains an invalid column value.
Cause
The above error occurs due to invalid data in a column of a table as invalid floating point values as SNAN, QNAN, NINF, ND, PD, PINF etc. It can also happen due to out-of-range data or hardware issues.
Solution
To correct the above issue, you need to follow any of the below methods:
You should find the affected rows and manually update them with correct values. To do this, you can execute T-SQL (Transact-SQL) queries against the table or alternatively, refer to the information provided by error 2570. You can set it to any of acceptable default or specific value.
Note: You can’t run DBCC command to repair the database as it can’t determine
the value to be placed instead of invalid column value.
In case if affected rows are large in number and it is not possible to update them manually, you can restore them from backup
If the above measure is not feasible because of backup unavailability or corruption, you need to use MDF Recovery applications to safely repair and restore your database. Such MDF Repair software use powerful scanning algorithms and offer advanced repair and restoration options together with interactive user interface.
Stellar Phoenix SQL Recovery is the foremost SQL Repair tool to repair damaged SQL databases. With self-descriptive interface, advanced repair options and read-only nature, it is an effective tool to repair all database objects. It supports SQL Server 2005 and SQL Server 2000. The software is compatible with Windows Vista, XP, 2003, 2000 and NT.
Thursday, August 13, 2009
The system cannot self repair this error - while accessing SQL database
Database Console Commands (DBCC) check the logical and physical consistency of the SQL database and can also resolve few detected error messages. But there are many issues that can not be resolved by using DBCC commands. In such scenarios, the SQL database corruption mainly occurs due to corrupt metadata, corruptions in certain critical system base tables or hardware failure. For absolute and systematic recovery of SQL database, the user needs to use effective SQL Recovery application.
The error message that appears when a user attempts to access SQL database is:
“The system cannot self repair this error”
After a user encounters the above error message, the data saved in the SQL database becomes inaccessible. The main cause of the above error message is SQL database corruption due to corrupt system database files, Page Free Space (PFS) page damage or corrupt metadata. Another main reason for the above error message can be faulty hardware. To resolve the above error and access the data in SQL database, the user needs to follow these steps:
1) The user can restore the database from latest backup.
2) The user can run DBCC commands with repair option. (For the above error message, the DBCC command can not repair the database.)
3) If there is a hardware issue, the user needs to replace the hard drive.
If the above measures fail to perform, then the user needs to recover the inaccessible data by using efficient SQL Server Recovery software. A SQL Recovery application incorporates advanced and powerful scanning algorithms to recover the lost data.
Stellar Phoenix SQL Database Recovery is the most advanced SQL Recovery software that repairs and restores the corrupted and damaged .mdf files from MS SQL Server database. With Stellar’s SQL repair software, you can perform complete SQL Database Recovery in all possible data loss scenarios. This read only SQL Repair application can Repair SQL objects including tables, views, saved procedures and triggers. It provides interactive and intuitive user interface and supports MS SQL Server 2005 and MS SQL Server 2000. This SQL Repair utility can also recover and restore the backup files of MS SQL Server.
The error message that appears when a user attempts to access SQL database is:
“The system cannot self repair this error”
After a user encounters the above error message, the data saved in the SQL database becomes inaccessible. The main cause of the above error message is SQL database corruption due to corrupt system database files, Page Free Space (PFS) page damage or corrupt metadata. Another main reason for the above error message can be faulty hardware. To resolve the above error and access the data in SQL database, the user needs to follow these steps:
1) The user can restore the database from latest backup.
2) The user can run DBCC commands with repair option. (For the above error message, the DBCC command can not repair the database.)
3) If there is a hardware issue, the user needs to replace the hard drive.
If the above measures fail to perform, then the user needs to recover the inaccessible data by using efficient SQL Server Recovery software. A SQL Recovery application incorporates advanced and powerful scanning algorithms to recover the lost data.
Stellar Phoenix SQL Database Recovery is the most advanced SQL Recovery software that repairs and restores the corrupted and damaged .mdf files from MS SQL Server database. With Stellar’s SQL repair software, you can perform complete SQL Database Recovery in all possible data loss scenarios. This read only SQL Repair application can Repair SQL objects including tables, views, saved procedures and triggers. It provides interactive and intuitive user interface and supports MS SQL Server 2005 and MS SQL Server 2000. This SQL Repair utility can also recover and restore the backup files of MS SQL Server.
Subscribe to:
Comments (Atom)