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
- 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
-
Verify the SQL Server instance service can start standalone on each node.
-
Remove the
.marker
file from the local instance installation data folder. -
Re-attempt virtualization.