Skip to main content
Version: v23.0

Incomplete Registry Restore Detected for Prior Local Registry Backup

Summary

When adding an instance to a Vhost, you see the following error:

add-instance completed with status code 99 - Incomplete registry restore detected for prior local registry backup

Information

This error occurs when a previous registry backup has encountered an unrecoverable error. This can potentially leave the current registry backup in an invalid state. The failure of a previous registry backup attempt is indicated by the presence of a .marker file in the local SQL Server data directory.

Resolution

  1. Verify the SQLArgs for the instance in the registry are pointing to the local installation path for SQL Server.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL<version>.<instance_name>\MSSQLServer\Parameters
  1. Verify the SQL Server instance service can start standalone on each node.

  2. Remove the .marker file from the local instance installation data folder.

  3. Re-attempt virtualization.