subject: How To Fix Missing Checkpoint For Registry Subkey Of Sql Server Agent? [print this page] You may come across SQL Server database corruption if the registry checkpoint of SQL Server agent is missing. In this case, SQL Server Agent cannot be found and MS SQL Server cannot start up. In such situations, MDF (Master Database File) of SQL Server becomes inaccessible and you come across critical data loss situations. To work around this problem, MDF Database Recovery is essential, if you do not have an updated backup.
As a practical example of this problem, consider this scenario:
The Registry checkpoint of SQL Server Agent is missing due to some unexpected deletion or unexpected corruption problems in the clustered instance of MS SQL Server 2008.
Clustered instance of Microsoft SQL Server 2008 is repaired.
In the above scenario, you cannot find the registry subkey, which is associated with the SQL Server Agent, in list of the checkpoints of SQL Server Network Name resource. SQL Server Network Name is associated with clustered instance. Furthermore, updates of SQL Server Agent application configuration aren't spread to other cluster nodes when SQL Server resource group goes to the nodes.
The below registry subkey is used by SQL Server Agent:
