Thursday, September 17, 2009

Damage Registry of SQL Server Agent Cause Database Corruption in SQL Server 2008

Registry is the most important component of Microsoft Windows operating system. Whenever you install a software (such as Microsoft SQL Server 2008) or hardware on your computer, a new registry hive is created. But in case if the registry entries of Microsoft SQL Server gets damaged, the database corruption might occur and it may become inaccessible. In such situations, you encounter data loss circumstances and need to go for SQL Recovery solutions to get your valuable data back.

For example, consider the below scenario:

In the clustered instance of MS SQL Server 2008, SQL Server Agent registry checkpoint is missing due to some unexpected corruption problems or deletion problems.
You repair clustered instance of MS SQL Server.

In above scenario, the Windows registry subkey, which is associated with MS SQL Server Agent isn't found in list of checkpoints of SQL Server Network Name resource. The resource is associated with clustered instance. Furthermore, updates for SQL Server Agent application configuration aren't propagated to other nodes of cluster when SQL Server group of resources move to those nodes.

Below is the registry subkey, which applies to the SQL Server Agent:

HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft\SQL Server\\SQLServerAgent


In order to sort out this problem, go through underwritten steps:

Point to Start-> Run and type cmd and click OK button.
Type cluster . resource /checkpoints on command prompt and press Enter key.
Check whether the below registry key appears in the result of above command:
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\\SQLServerAgent
If the registry does not appear, then type below command and press Enter key:
cluster . resource /addcheckpoints:"HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\\SQLServerAgent"

If this method can not help you to sort out the issue, then you are required to repair and restore the database to carry out SQL Repair. This is possible with the help of powerful third party applications, known as SQL Recovery software.

These tools use advanced and efficient scanning mechanisms to carry out in-depth scan of affected SQL Server database and retrieve all of the corrupt or inaccessible objects. The SQL Recovery softwre are generally easy and safe to use. They do not demand high technical skills.

No comments:

Post a Comment