Tuesday, September 29, 2009

Damaged SQLServerAgent Service Might Cause MDF Corruption

Microsoft SQL Server is an advanced RDBMS (Relational Database Management System), which include a service called SQLServerAgent for managerial operations of MS SQL Server, known as Jobs. This service executes the jobs and monitor the tasks for SQL Server. It is also able to process the SQL Server alerts. But in some situations, where the SQLServerAgent gets damaged, database might get damaged and become inaccessible. In these situations, you can not access your mission critical data from the damaged database and need to opt for SQL Recovery to get your data back.

In MS SQL Server, a job is usually a collection of steps that are particularly designed for the simplification of tasks of users. There are several functions that could be carried out through the jobs and information of these jobs is stored in SQLServerAgent. The critical functions include backing up the database that could be generated on regular intervals, specified as per users' choice. But if the functioning of this utility is aborted, then backup process might get terminated and some other database operations may also get terminated.

This utility tells you about the errors in the database, which occurs while executing the database jobs. But in case if the error numbers raise, which have six or more digits then heap corruption might take place in SQLServerAgent service. At this point, you might come across below error message in the sqlagent.log file:

“The ExecReAlloc memory operation failed (request [for 1508 bytes] occurred at line 2409 of function ODBCErrorHandler)”

In such circumstances, you would not be able to access the service and thus no database job will run. This behavior of SQL Server renders entire database inaccessible and cause MDF corruption. To gain access of your mission critical data in these cases, SQL Repair is required.


The major reason behind this problem is the routine for procession the errors in SQLServerAgent doesn't allocate disk space that is sufficient for storing errors numbers that is greater than 5 digits. To prevent this issue, Microsoft recommends you to use error numbers that are 5 digits long.

In case of corruption, you are required to repair and restore damaged database through SQL Recovery solutions. Recovery is best possible using third party applications. These tools are quite effective in most of the database corruption situations. SQL Repair using these applications is completely safe and easy.

No comments:

Post a Comment