Friday, April 30, 2010

SQL Server Instance Does Not Start After Restoring Model System Database

Microsoft SQL Server holds a set of the system database that are required for options of Microsoft SQL Server instance. You should backup the system database after each critical update, to prevent database corruption. The system database backup must include model, master, and msdb. You can restore Microsoft SQL Server easily from backup, in the event of the system failure. However, in some situations, the SQL Server's MDF (Master Database File) file may become completely inaccessible after you restore a model system database from backup. It leads to critical data loss situations and requires SQL Database Recovery to work around the problem if backup is not updated.

In a practical scenario, you may not start an instance of SQL Server successfully, when you attempt to initialize any instance of MS SQL Server after restoring model system database using 'WITH NORECOVERY' option. Furthermore, you may come across the below error message in the application error log of Microsoft SQL Server at the same time:

“2003-04-18 09:37:38.85 spid5 Starting up database 'model'.
2003-04-18 09:37:39.24 spid5 Bypassing recovery for database 'model' because it is marked IN LOAD. 2003-04-18 09:37:39.65 spid5 Database 'model' cannot be opened. It is in the middle of a restore.”

This behavior of Microsoft SQL Server renders entire MDF database file inaccessible and serious data loss occurs. To retrieve data from affected database, you need to Repair SQL Server database file by fixing this problem.

Root of the problem

When the model system database is restored using 'WITH NORECOVERY' option, restore options leaves your SQL Server model database in unrecovered state. Thus, you can no longer use the model system database as expected. Due to the same, SQL Server may not function effectively.

Resolution

To sort out this behavior, clear 'Loading' status of model system database in instance of Microsoft SQL Server. In case the SQL Server database is severely damaged and model database is also affected, reinstall SQL Server application and restore database from updated backup.

If you do not have backup, use third-party MS SQL Recovery software to repair and restore the database into accessible and working state. The SQL Recovery applications use advanced scanning algorithms to systematically scan whole database and extract all inaccessible objects from it.

SQL Recovery is a powerful, yet easy to use and safe utility to ensure absolute recovery in all SQL Server database corruption scenarios. The software works well with Microsoft SQL Server 2008, 2005, and 2000. It restores all MDF file objects, such as tables, reports, forms, macros, constraints, stored procedures, and triggers.

Wednesday, April 28, 2010

Recovering Error 2575 in SQL Server 2008

A page is the most basic unit of storage in SQL Server. The memory space allotted to a database file is divided into pages having contiguous address location. And these pages are, in turn, stored in extents, which are a collection of eight contiguous pages. The role of the extents is to effectively manage the pages. An Index Allocation Map (IAM) is a page type that stores the details about the extents used by a table per allocation unit. These are also used by SQL Server to traverse through a heap to locate the available space for new rows. However, sometimes these IAM pages do not function properly because of corrupted databases. A database can become corrupt because of virus infections, human errors, faulty hardware, power outages, etc. In such cases, you should consider taking appropriate measures to recover the database. However, if you are not able to repair the database then you should use a third-party application for MS SQL Recovery.

Consider a scenario wherein you receive the following error message when you try to mount your SQL Server 2008 database.

“IAM page P_ID1 is pointed to by the next pointer of IAM page P_ID2 in object ID O_ID, index ID I_ID, partition ID PN_ID, alloc unit ID A_ID (type TYPE) but was not detected in the scan.”

The error message states that the IAM page was found for the current index but it was not found for the next-page pointer.

Cause:
There could be two possible reasons for the aforementioned error message, either the reference of the metadata file missing or the header of the IAM page is corrupt. Because of this, the database has gone corrupt.

Resolution:
To resolve the issue, you can perform the following measures:
Look for hardware failures: Do check if this error is because of faulty hardware. Run hardware diagnostics and check the error logs and rectify the hardware-related errors, if any. You should also look to swap different hardware components if the database is getting corrupt frequently. Also, you can also contemplate using a new hardware system. However, this would mean formatting the hard disk and reinstalling the operating system, which is not required as it would erase the database as well.
Replace the corrupted database with a clean backup.
Run DBCC CHECKDB command without a repair clause to check the extent of the corruption. Then, run it again with the appropriate repair clause after determining it.

However, if you are still not able to repair the corrupted database then you should use a third-party SQL Server recovery application to recover SQL database. Such read-only tools perform SQL Recovery using fast yet sophisticated scanning algorithms without overwriting the damaged area.

SQL Recovery software is a robust tool that enables you to execute SQL recovery on corrupted SQL database components such as tables, defaults, stored procedures, triggers, views, and rules. It is also able to repair the database constraints such as primary key, foreign key, unique key, and check. The MS SQL recovery utility recovers corrupted databases that were originally created in MS SQL Server 2000, 2005, and 2008. The software is compatible with Windows 7, Vista, Server 2003, XP, and 2000.

Tuesday, April 27, 2010

Recovering corrupt index in SQL Server 2008 – Error 2530

MS SQL Server uses indexes to quickly find the records when a query is executed. Actually the SQL Server uses the index in a similar way as you would read a book. If you want to search a particular topic, you do not have to traverse each and every page. You would just look for it in the index and open the page/section directly. Following the same pattern, an index has got keys that are built from one or more columns in the table and pointers that refer to the storage location of the queried data. Well-defined indexes can improve the system performance remarkably as the amount of data that is read to fetch the query result. However, at times the index can get disabled because of various reasons such as power surges, virus infections, human errors, etc. In such cases, you should consider taking appropriate actions to resolve the issue. However, if you are not able to address the issue then you should use a third-party SQL Database Recovery tool to repair SQL database.

Consider a scenario wherein you are working on SQL Server 2008 system when you encounter the following error message:
“The index "%.*ls" on table "%.*ls" is disabled.”

Cause:
This error message is displayed when the index is disabled. The DBCC command cannot proceed when the index is disabled. There could be following reasons for this:
You have disabled the index manually by using ALTER INDEX.
The index is disabled as the database is corrupt.

Resolution:
To resolve this error message, you need to either rebuild it or drop it and recreate it. To do this, you can perform the following methods:
1.First of all, enable the index by using either of the following methods:
ALTER INDEX statement with the REBUILD clause
CREATE INDEX with the DROP_EXISTING clause
DBCC DBREINDEX
2.Rerun the DBCC command.

However, if you still are not able to address the issue, it means that the database is corrupt. In such a case, you should consider using a third-party SQL repair application to SQL Recovery. Such read-only tools repair SQL databases without overwriting the original data.

SQL Recovery software is a robust tool that enables you to repair and restore database components such as tables, defaults, stored procedures, triggers, views, and rules. It is able to perform mdf repair for the databases created in SQL Server 2000, 2005, and 2008. It can also recover index, database constraints, user-defined functions, and user-defined data types. It is compatible with Windows 7, Vista, Server 2003, XP, and 2000.

Resolving 8905 and 8924 DBCC CHECKDB Failure Errors

To resolve logical damages in MS SQL Server database, an easy way followed by most database users is to execute DBCC CHECKB (with appropriate repair clause). This command after checking the logical and physical integrity of the database, repairs the database to the maximum possible level. However, if the command fails to repair, then it displays a severity level (either 10 or 16) error message(s). This error message helps the user identify the exact cause of database corruption. After any of the above error message(s) appears, the data saved in the database becomes inaccessible. To access the records in such cases, the user needs to restore the database records from an updated backup. But, in case no backup is available or backup falls short of restoring the database records, the database users need to repair the database using an efficient SQL Database Recovery application.

The above scenario can be explained with the help of the below error message:

“Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886000) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 1
Extent (1:886112) in database ID 37 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
...”

This error message appears when the user executes a DBCC CHECKDB command to repair his/her logically corrupted SQL Server 2000 database. Additionally, the same error message appears every time you try to repair your database.

Cause:

The above error message appears when the SQL Server 2000 database corruption is beyond the repair capabilities of DBCC CHECKDB command.

Resolution:

To resolve the above error message and to access the database records, the user needs to follow the below steps:

Restore database from an updated, valid, and complete backup.
Use a third-party SQL Database Repair application in case no backup is available. A commercial MS SQL Recovery utility can repair any logically damaged database, even if it cannot be repaired by DBCC CHECKDB command.

Stellar Phoenix SQL Recovery repairs MS SQL Server 2008, 20005, and 2000 database damaged due to logical crash. The SQL Repair tool is absolutely safe. It can be installed on Windows 7, Vista, 2008, XP, 2003, and 2000.

Sunday, April 25, 2010

DBCC CHECKTABLE Doesn't Work on a Table That Has Corrupted Indexes

Microsoft SQL Server stores all your valuable data in the MDF (Master Database File) in the form of tables. You can access data from the SQL Server database tables, using SQL queries. Under some circumstances, the database tables become inconsistent and you cannot access data from it. This behavior of MS SQL Server leads to significant data loss situations. At this point of time, you must have absolute backup of the database to restore the data from. However, if the backup is not available or not updated, you are required to use MS SQL Recovery applications to extract inaccessible data.

When you run the DBCC CHECKTABLE command on MS SQL Server database table to check the consistency and integrity of the table, you may come across the below error message:

“[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionCheckForData (PeekNamedPipe()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.”

The table checking gets terminated with this error. The error message occurs in the SQL Server database table, which has damaged indexes. The table remains inaccessible after this error message and you need to Recover SQL database to extract data.

DBCC CHECKTABLE is an in-built command-line utility in Microsoft SQL Server, which is used for checking the consistency and integrity of all structures and pages, which make up the indexed view or table.

Cause

You may come across this behavior of Microsoft SQL Server due to severe corruption in the SQL Server database table. The table corruption may occur due to numerous reasons, such as virus infection, application malfunction, unexpected system shutdown, hardware problems, operating system malfunction, and more.

Resolution

Try out the below steps to sort out this problem:

Obtain the latest service pack of Microsoft SQL Server. It helps you to prevent this problem from being occurred in future.
Drop all the automatically created statistics.
Restore SQL Server database from the most recent backup.
Repair and restore the damaged SQL Server database using powerful and advanced third-party applications, known as SQL Server Recovery software.

The SQL Server Recovery applications are particularly designed to carry out in-depth scan of entire SQL Server database using high-end scanning techniques and extract all inaccessible data from it. The software has read-only conduct and rich graphical user interface to ensure quick, safe, and easy recovery in all cases of SQL Server database corruption.

SQL Recovery software repairs and restores Microsoft SQL Server database in an absolute way. The software works well with Microsoft SQL Server 2008, 2005, and 2000. It restores all damaged objects of Microsoft SQL Server database, such as tables, reports, forms, macros, view, constraints, triggers, and stored procedures.

Thursday, April 22, 2010

Recovering SQL database from the Error: 0x80004005 E_FAIL Minor error

Those of you who are working with SQL Server database in your organization must be knowing how the database grows with time. The database files can grow quickly, which sometimes hampers the performance of the system. Moreover, the internal structure of the database may get fragmented with time that eventually result in wastage of the disk space. To remove the fragments and make the system faster, you should use Compact and Repair utility in SQL Server. However, sometimes when you try to access the database, it does not open as intended and throws some error message. In such cases, you should take appropriate measures to address the issue. It may be possible that the database is corrupt. Then, you should replace it with updated backup. And if the backup is not available, then you should consider using a third-party SQL Recovery tool.

Consider a scenario wherein you are working on a database and you have tried to open a connection in the Query Analyzer. The connection fails and an error message is displayed, that is:

“Error: 0x80004005 E_FAIL
Minor Error: (25017)
Description: Unspecified Error”

A Microsoft embedded Visual Basic (eVB) application that uses CompactDatabase method is not able to compact a corrupted SQL Server CE database.

Cause:

The root cause for this error message is that the database that you are trying to compact is corrupt. This can be inferred from the fact that when CompactDatabase utility is used, the ActiveX code tries to initialize the source database before compacting it. If the initialize fails, CompactDatabase aborts. Hence, you cannot use CompactDatabase on a corrupted database because the Initialize method on a corrupted database always fails.

Resolution:

To resolve this issue and recover SQL database, you should obtain the latest service pack for Microsoft SQL Server 2000 Windows CE Edition. If the issue is not resolved, you should use a third-party SQL Database Recovery tool. Such tools employ fast yet sophisticated algorithms to scan damaged area for performing MS SQL recovery.

SQL Recovery software is an efficient tool that can perform SQL server recovery on the databases created in MS SQL Server 2008, 2005, 2000. It is able to recover various database components such as identity, rules, tables, indexes, defaults, stored procedures. This SQL recovery tool can also recover database constraints such as primary key, foreign key, unique key, check, etc. It is compatible with Windows 7, Vista, 2003 Server, XP, 2000.

Wednesday, April 21, 2010

Recovering database from corrupt filegroups in SQL Server – Error 2522

If you are a database backend user in your organization, then you must be knowing how the size of the database increases immensely within a span of a few months. If yours is a growing organization, then the issue gets even more aggravated as you have to regularly maintain the database. For this purpose, SQL Server 2005 provides various options to support database growth. One of them is creating a filegroup that can loosely be termed as a logical storage unit containing the database objects that map to a file system file or multiple files. In this, additional disk drives are allocated to support estimated growth of the database. Then, the additional files can be shifted to these filegroups to spread the I/O over additional disks. However, even the filegroups-supported database can get corrupt due to various reasons. In such cases, you should replace corrupt database with its updated backup. However, if the backup is not available then you should consider using a SQL Database Recovery tool.

Consider a scenario wherein you have received the following error message when you open the SQL database:
“Unable to process index I_NAME of table O_NAME because filegroup F_NAME is invalid.”

The aforementioned message states that the index cannot be checked as one of the filegroup IDs, which is stored in the index metadata, does not exist.

Cause:
The root cause of this error message is that the filegroup IDs stored in the metadata for an index do not exist so that index can not be checked. It may be possible that the database is corrupt.

Resolution:
To start off, you should check whether this error message is because of some hardware failures. You should run the hardware diagnostics, check the SQL Server error log, etc. If the error is not hardware-related then you should replace the database with an updated backup. However, if you do not have the backup then you should consider using a third-party SQL Server recovery tool to Recover SQL database.

SQL Recovery software is a robust tool that can perform SQL recovery on the databases created in MS SQL Server 2008, 2005, 2000. It employs fast and complex algorithms to scan the damaged area to repair the databases. The SQL database recovery tool is able to recover various database components such as identity, rules, tables, indexes, defaults, stored procedures. It can also recover database constraints such as primary key, foreign key, unique key, check, etc. It is compatible with Windows 7, Vista, 2003 Server, XP, 2000.

Tuesday, April 20, 2010

How to resolve Error 2501 in SQL Server?

A lot of users prefer using MS SQL Server as the Relational Database Management System (RDBMS) both at their home as well as their workplace. This is so because it is a robust RDBMS, which is designed to conform to the enterprises environment, organizations, and high-end users with their advanced needs. However, sometimes the SQL database file (.MDF) may get corrupted due to various reasons such as virus infections, software failure, improper shut down while database is open, etc. In such cases, you should replace corrupted database with its updated backup. However, if it is not available then you should consider taking appropriate measures to SQL Recovery Server database.

Consider a scenario wherein you are working on a SQL Server database that is the master database of your organization. You try to open one of the tables but it fails to open and gives an error message, that is:

“Could not find a table or object named '%.*ls'. Check sysobjects.”

The aforementioned error message signifies that the table has become corrupt and, therefore, you cannot access the database records.

Cause:
The root cause of this error message is that the table specified in the DBCC CHECKTABLE was not found. It may have happened that the table did not exist or the metadata of the database was corrupt.

Resolution:
There are following measures that you can take in such situations:
First of all, make it a point to check if the table exists or not.
Replace the corrupted table with its updated backup.
Run DBCC CHECKDB without a repair clause to find out the effect of the data corruption. DBCC CHECKDB will recommend a repair clause to use. Then, use the recommended repair clause with DBCC CHECKDB.

If all the aforementioned measures are unable provide the SQL Database Recovery, then you should use a third-party MS SQL recovery tool. These read-only tools are highly interactive, and enable you to repair and recover the database components using sophisticated scanning algorithms.

SQL Recovery software enables you to repair and recover all the SQL components such as tables, rules, views, stored procedures, indexes, Defaults, Triggers, etc. In addition, it can successfully repair user defined functions and data types. It can repair the databases created in MS SQL Server 2008, 2005, 2000. It is compatible with Windows 7, Vista, 2003 Server, XP, 2000, and NT.

Monday, April 19, 2010

How to resolve the Error 8948 in MS SQL Server 2000?

MS SQL Server is a Relational Database Management System (RDBMS) that is well designed to conform to the advanced needs of enterprises environment, organizations, and high-end users. It provides various tools to ease the burden of database development, maintenance and administrations. One of them is Page Free Space (PFS). It is a page in the database that searches for free space in the table. It contains a byte-map that holds one byte per page (P_ID), approximately 64 MB, in a PFS. However, sometimes P_ID is assigned to a PFS and you are not able to access the page. In such cases, the database becomes inaccessible and may get corrupt. You should replace the database with updated backup. If the updated backup is not available, then you should use an SQL Database Recovery tool to recover SQL database.

Consider a scenario wherein you encounter an error message when accessing a database table in MS SQL Server. The error message is:
“Database error: Page P_ID1 is marked with the wrong type in PFS page P_ID2. PFS status 0xVAL1 expected 0xVAL2.”

After encountering the aforementioned error message, you are unable to access the table or perform any other operation on it.

Cause:
The error message may have occurred because the bits are not set correctly in the database table, given the type of page and context in which it is read.

Resolution:
To resolve this issue, you can take the following measures:
Run hardware diagnostics and see if the data corruption is because of hardware failure. Try different hardware configurations to check if it is because of any hardware failure.
Replace the database table with its updated backup.
Run DBCC CHECKDB without a repair clause to find out the effect of the data corruption. DBCC CHECKDB will recommend a repair clause to use. Then, use the recommended repair clause with DBCC CHECKDB. The idea behind using DBCC CHECKDB is to set the PFS byte to the correct free space bits and to set them appropriately.

However, if you are not able to do SQL Recovery using the aforementioned measures then you should use a SQL database recovery tool. These read-only tools are highly interactive and employ complex algorithms to scan the damaged area to recover it.

SQL Recovery software is able to repair all the SQL components such as tables, rules, views, stored procedures, indexes, Defaults, Triggers, etc. In addition, it can successfully repair user defined functions and data types. This sql database recovery tool can repair all the databases created in MS SQL Server 2008, 2005, 2000. It is compatible with Windows 7, Vista, 2003 Server, XP, 2000, and NT.

SQL Server Can Not Recognize MDF File After Improper System Shutdown

MDF (Master Database File) is the repository of all valuable data in the Microsoft SQL Server. Data is stored in the form of tables. However, in some situations, improper system shutdown may make your database faulty and inaccessible. This is because unexpected shutdown may damage the database. Microsoft SQL Server can not read the corrupted database and thus you face data loss. In such critical situations, you need to opt for SQL Database Recovery solutions if the backup is not updated.

Improper system shutdown may occur due to numerous reasons, such as system crash, power outages, application freezing, unresponsiveness of the system, and more. As a practical example of this problem, you may encounter the below error message when you reboot your system after an unexpected system shutdown and try to attach the MDF file manually:

“TITLE: Microsoft SQL Server Management Studio Express
Failed to retrieve data for this request.
(Microsoft.sqlserver.Express.smoenum)
For help, go to Microsoft help

ADDITIONAL INFORMATION: An exception occurred
while executing a Transact-SQL statement or batch.
(Microsoft.sqlserver.Express.connectioninfo
D:\Data\MSSQL\ISEC.mdf is not a primary database file.
(Microsoft SQL Server, Error: 5171) For help, go to Microsoft help

After this behavior of Microsoft SQL Server, you can not access the database. It results in severe data loss. In order to access your valuable data, it is essential to identify the root of the problem and perform SQL Server Recovery by resolving it.

Cause

Microsoft SQL Server can not read the damaged MDF file. In such cases, the problem occurs when SQL Server attempts to read data from damaged files and fails. Corruption is caused by improper system shutdown, which damages critical data structures and important system files of SQL Server database.

Resolution

You can work around this problem by restoring the damaged MDF file from an updated backup. Backup is the redundant copy of the database, which is maintained to prevent data loss. However, if the database backup is either not updated or is damaged, you need to use third-party SQL Recovery software to restore your database.

The applications are specifically designed to carry out in-depth scan of entire database and extract inaccessible data from it. They do not demand sound technical skills due to their simple and interactive user interface. Such tools perform safe SQL Recovery owing to their read-only conduct, by virtue of which they apply complex algorithms to read data from the original file. This data is simultaneously saved in a newly created file, thus leaving the original file intact.

SQL Recovery software repairs and restores damaged SQL Server database in all cases of corruption. The software works well with Microsoft SQL Server 2008, 2005, and 2000. It restores all MDF file objects, such as tables, reports, forms, macros, stored procedures, triggers, and more.

Friday, April 16, 2010

Fixing “The low key value on page P_ID1...” Error

The physical storage of data stored in a MS SQL Server table can either be performed in a B-tree or heap structure. The B-tree structure consists of a two types of pages – parent page and child page. The parent page contains at least two child pages and keeps a record of every child page. In case the child page is at the last level (leaf-level), then all the records on that page should contain key values equal to or greater than the key value in the parent page. However, in case the child page is at tree level, then the key values should be greater than the key value in parent page. But, if these key values are not in accordance, then you might receive an error message that stops you from accessing its records. This mainly happens when the MS SQL Server database is logically or physically damaged. In such situations, you need to repair the database using a commercial SQL Database Recovery, if you have not maintained any backup.

Consider a practical case wherein you encounter the below error message while trying to access your MS SQL Server table:

“Table error: Object ID O_ID, index ID I_ID. The low key value on page P_ID1 (level LEVEL) is notCOMPARISON the key value in the parent P_ID2 slot S_ID.”

This is a severity level 16 error message. After the above error message pops up, the records saved in the table become inaccessible.

Cause:

The above error message appears due to corruption of MS SQL Server database.

Resolution:

To fix the above severity level 16 error message and to access the table records, you will need to follow the below steps:

View the system, application, and SQL Server logs, to identify physical corruption. After the damaged component is identified in the logs, change the component.

To identify logical damage, you will need to run DBCC CHECKDB command without a repair clause. After identifying the level of logical damage, run the same command with a suitable repair clause. However, if the error message persists even after running the above command, then you need to repair your database using an effective third-party SQL Database Repair application. Such SQL Recovery tools use effective repair techniques to repair logically damaged databases.

SQL Recovery is one powerful SQL Repair tool to repair MS SQL Server 2008, 2005, and 2000 databases. The software allows the database administrator to preview the repaired database before saving it at required location. It is designed for Windows 7, Vista, 2008, XP, 2003, and 2000.

Thursday, April 15, 2010

DBCC CHECKDB Process Fails With “Error 8967” in SQL Server

Microsoft SQL Server is a widely used relational database management system, which stores all the data in MDF (Master Database File). It provides an inbuilt utility to check the physical and logical integrity of the objects in specified database through a series of operations. However, in some situations, this tool fails to check the integrity and consistency of the SQL Server database and the database remains inaccessible. In such situation, you may face critical data loss situations and need SQL Database Recovery.

As an example of this problem, consider the underwritten scenario:

You restore Microsoft SQL Server 2005 or Microsoft SQL Server 2008 database from backup.
You encounter errors while restoring the database and the restore process fails.
You restore database from same backup using CONTINUE_AFTER_ERROR option.

In such cases, when you use DBCC CHECKDB command-line utility on computer, which has MDF file, you get the below error:

“Msg 8967, Level 16, State 216, Server , Line 2
An internal error occurred in DBCC which prevented further processing. Please contact Customer Support.
DBCC results for ''.
Msg 8921, Level 16, State 1, Server , Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.”

Furthermore, you may see the below error in error log of SQL Server:

“2007-05-26 07:13:49.21 spid58 DBCC encountered a page with an LSN greater than the current end of log LSN () for its internal database snapshot. Could not read page (file id:page id), database '), LSN = (), type = 32, isInSparseFile = 1. Please re-run this DBCC command.”

Cause

You face this problem if DBCC CHECKDB command can't perform required checks for confirming database consistency due to severe corruption.

Solution

In such critical situations, you need to restore database from the latest backup. But, if the backup is either not available or not updated, SQL Server Recovery becomes need of hour.

You can recover your damaged SQL Server database using powerful MS SQL Recovery software. The applications are powerful enough to systematically scan whole database and extract all inaccessible objects from it. They offer easy SQL Recovery with simple and interactive user interface.

SQL Recovery software successfully repairs and restores damaged SQL Server database using powerful techniques. It is designed for Microsoft SQL Server 2008, 2005, and 2000. The software restores all of the MDF file objects, including tables, reports, forms, macros, stored procedures, and triggers.

Tuesday, April 13, 2010

CompactDatabase Process Fails on a Damaged MS SQL Server Database

Microsoft SQL Server is a popular relations database management system. It stores all your valuable data in the MDF (Master Database File). In case of corruption of the MDF file, due to virus infection, improper system shutdown, and other such reasons, the database become totally inaccessible. This behavior of MS SQL Server leads to significant data loss. In some cases of corruption, you can not even run the repair utility or open database connections after corruption. In such situations, you need to restore database from backup. If the backup itself is corrupt, SQL Database Recovery is required to sort out the problem.

In a practical scenario, you may get the below error message on a damaged SQL Server database in Microsoft SQL Server 2000 Windows CE Edition Query Analyzer when you try to open any connection:

“Error: 0x80004005 E_FAIL
Minor Error: (25017)
Description: Unspecified Error”

The error code in this error is SSCE_M_DATABASECORRUPTED (the SQL Server database file is corrupted or it is a Non-database file)

A eVB (Microsoft embedded Visual Basic) application, which uses CompactDatabase method isn't capable of compacting the damaged Microsoft SQL Server CD database. When you attempt to call CompactDatabase method, you may come across the below error message:

“Error: -2147467259
Compact”

To recover inaccessible data from the SQL Server database in such situations, you need to identify the root of the problem and then resolve it through SQL Server Recovery tools.

Cause

You may face this problem due to severe database corruption. Engine ActiveX code for the CompactDatabase attempts to start source database prior to compact source database. In case the start process fails, CompactDatabase process aborts. Thus you can't use CompactDatabase method on damaged database as the initialization method on damaged database fails in all situations.

Resolution

To prevent this problem from occurring in future, obtain latest service pack of Microsoft SQL Server. To fix the current database corruption problem, repair and restore the database using powerful third-party SQL Recovery software.

The applications are very easy to use with simple and rich graphical user interface. They do not demand sound and prior technical skills to perform SQL Recovery. With read-only and non-destructive conduct, these tools preserve integrity of your database.

SQL Recovery software repairs and restores damaged SQL Server database in all corruption scenarios. The software works well with Microsoft SQL Server 2008, 2005, and 2000. It restores all MDF file objects, such as tables, reports, forms, macros, stored procedures, constraints, and triggers.

Sunday, April 11, 2010

Damaged Transaction Log Files May Cause SQL Server Database Corruption

In Microsoft SQL Server 2005 and Microsoft SQL Server 2000, every database includes at least one transaction log file and data file. MS SQL Server stores data physically in data file and details of the modifications that are performed on SQL Server database are stored in transaction log file. Logging the transaction details can't be turned off because transaction integrity is conceived an intrinsic and fundamental characteristic of MS SQL Server. In case of corruption or loss of transaction log file, you may come across SQL Server Database corruption. In such cases, you are required to perform SQL Database Recovery to retrieve data.

To prevent database corruption, one must prevent unexpected growth of transaction log files. To do so, follow the underwritten steps:

Set size of transaction log files to a large value for avoiding automatic expansion of transaction log files.
Configure automatic expansion of the transaction log files using memory units instead of percentage after evaluating optimum memory size.
Change recovery model. In case of data corruption or some disaster, you need to recover damaged database so you can maintain transaction integrity and data consistency of MS SQL Server database. Depending upon the significance of damaged database, you can go for any of the following database recovery models for determining how the data and information is backed up and what exposure you have to data loss:

Simple recovery model - To recover corrupt SQL Server database to most recent backup.
Full recovery model - Enables you to recover damaged database to a point when database failure occurred. It restores database using transaction log files.
Bulk-logged recovery model - It works in the same way as the Full recovery model does.

Backup transaction files regularly.
Do not continue running the uncommitted transactions.
Defragment indexes.

In case the above methods can not help you, and transaction log file gets damaged, you may face severe database corruption. In such situations, MS SQL Recovery is the only way to repair and restore damaged database.

The MS SQL Recovery applications use advanced database scanning techniques to thoroughly scan the damaged database and extract all data from it. They Recover SQL database in a safe and easy way with their read-only conduct and interactive graphical user interface.

SQL Recovery software safely repair and restores damaged SQL Server database in all cases of corruption. The software works well with MS SQL Server 2008, 2005, and 2000. It restores all damaged and inaccessible database objects, such as tables, reports, forms, macros, triggers, and stored procedures.

Thursday, April 8, 2010

Tips to resolve “Page P_ID1 was not seen in the scan...” Error Message

Tables in MS SQL Server contain thousand of records that are contained in more than one partitions. These partitions save data rows in either B-tree or heap structure. The table records saved in B-tree can be retrieved faster than in heap tree. The reason behind fast retrieval is that the data pages in B-tree are connected in a doubly-linked list. While the navigation process is faster in B-tree structure, the process might halt if any child page points to a wrong index page or is not pointing to any page. Such situations primarily occur when your database is corrupted. In such circumstances, a database user encounters an error message that makes the data saved in the table inaccessible. To access the records in such cases, the user can restore table from an updated backup or run DBCC CHECKDB command. However, if both the parameters fail to resolve, then the user needs to opt for a commercial SQL Database Recovery product.

Consider a practical example to elaborate the above problem where you encounter the below error message while accessing a MS SQL table:

“Table error: Object ID O_ID, index ID I_ID. Page P_ID1 was not seen in the scan although its parent P_ID2 and previous P_ID3 refer to it. Check any previous errors.”

This is a severity level 16 error message, that pops up and does not allow you to access the table records.

Cause:

The above error message appears when a child page (P_ID1) can not be seen even though the index page is pointing to the child page. This above situation occurs when the database is either logically or physically corrupted.

Resolution:

Corruption due to physical damages can be resolved by changing the damaged system component.
Corruption owing to logical reasons can be rectified by running DBCC CHECKDB command. But in case, the error message persists after executing DBCC CHECKDB command, then you will need to use third-party MS SQL Recovery tool to repair your table. Such SQL Repair application scan the database and repair it to the fullest.

SQL Recovery application is used to repair logically corrupted SQL database, regardless of its cause of corruption. The SQL Database Repair tool supports repair of every SQL Server database component built in MS SQL Server 2008, 20005, and 2000. It supports Windows 7, Vista, 2008, XP, 2003, and 2000.

Tuesday, April 6, 2010

False Positive and Database Consistency in Microsoft SQL Server

Are you facing various instances of the 'False Positive' on your Microsoft SQL Server when you run DBCC CHECKDB statement for checking database consistency? The problem may occur due to inconsistency of the MDF (Master Database File) of MS SQL Server. Database inconsistency can be due to numerous reasons, such as database corruption, missing database objects, and more. In all such cases, the database becomes completely unusable and you face severe data loss problems. In such circumstances, it becomes essential to perform SQL Database Recovery to overcome the problem.

For instance, when you run DBCC CHECKDB statement on your SQL Server database, it gives consistency errors in database tables. However, if you run DBCC CHECKTABLE statement to repair the table and fix inconsistency problems, it does not display any errors. When you face a false positive situation, you get either of the below errors:

“DBCC CHECKDB is performing an exhaustive search of indexes for possible inconsistencies.”

Or

“SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file in database .”

At the same time, Application Event Log of MS SQL Server may contain entries similar to the following ones:

Msg 8978, Sev 16, State 1, Line 1 : Table error: Object ID 1789795471, index ID 1, partition ID 72057602467495936, alloc unit ID 72057602585395200 (type In-row data). Page (1:2387522) is missing a reference from previous page (1:2387521). Possible chain linkage problem. [SQLSTATE 42000]
Msg 8958, Sev 16, State 1, Line 1 : repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB . [SQLSTATE 01000]

Cause

The problem occurs due to inconsistency or corruption in the MDF file. It may be due to unexpected system shutdown, virus infection, and other such reasons.

Resolution

You can get your database in working state by restoring it from an updated backup. After restoring the database, you must run database defragmentation. However, if the backup is not current, then only SQL Server Recovery can help you to extract inaccessible data.

Effective and absolute recovery is possible with SQL Recovery software. These are powerful third-party tools, which scan whole database and retrieve all damaged and inaccessible data from it. You need not have sound technical skills to use these MS SQL Recovery software as they have simple graphical user interface.

SQL Recovery is the most advanced utility that ensures perfect recovery of damaged SQL Server database. The software repairs and restores MDF files of Microsoft SQL Server 2008, 2005, and 2000. It recovers all SQL Server database objects such as tables, reports, forms, triggers, and stored procedures.

Sunday, April 4, 2010

Fixing “Could not repair this error” Error

Database corruption is unfortunate for any database administrator. Damage in database mainly occurs due to metadata structure corruption, improper shutdown of system or server, or malicious software like virus. Although most logical corruption in SQL Server database can be surmounted using DBCC CHECKDB repair command, there are some situations wherein the command fails to repair. These situations occur when the database is severely corrupted and beyond the repair limits of DBCC CHECKDB. In such cases, it is advisable to restore database from an updated backup. But if the backup is unavailable or deficient, then the administrator needs to search for a third-party SQL Database Recovery application.

To illustrate above problem, consider a database administrator receives a database corruption error message while trying to access database. However, on trying to repair database using DBCC CHECKDB command, another error message is encountered:

“Could not repair this error.”

This is severity level 10 error message. As the error message states, the in-built repair command is unable to repair the database. After the above error message flashes, the data saved in the database becomes inaccessible. In addition, the same error message is encountered on every attempt to repair database, using different repair parameters.

Cause:

The repair command fails to repair the database because:

There is severe damage in PFS (Page Free Space), GAM (Global Allocation Map), or SGAM (Shared Global Allocation Page) pages.
Database corruption requires rebuilding of clustered indexes for all or few system tables.

Resolution:

To surmount the above error message and to access the database records, you will need to:

Restore the database from an updated backup.
In case of no backup availability, you need to opt for a commercial SQL Database Repair product.

Such SQL Recovery applications use advanced scanning and repairing techniques to repair any logically corrupted database. These tools can be installed from the Internet and do not require any technical knowledge to perform repair process. Such repair utilities do not make even a single change in the original database.

SQL Recovery comprehensively repairs and restores all SQL Server databases, irrespective of their cause of damage. The SQL Repair utility supports repair of MS SQL Server 2008, 20005, and 2000 databases. It is compatible with Windows 7, Vista, 2008, XP, 2003, and 2000 operating systems.