I haven't touched SQL server for two or three years. Today, due to the company's needs, I picked it up and learned it again (I forgot it before ). I don't want to encounter an old problem when I just installed it-"a previous program has been installed on the installation computer to create a pending file operation ".
Solution,
Find the PendingFileRenameOperations project in HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control/Session Manager and delete it. In this way, you can clear the temporary installation project.
It is located on the right side of the registry. Find it and delete it. Click next to avoid the above problems. To reinstall the agent, perform the following steps:
1. Add/delete programs to completely delete SQL server.
2. Delete the SQL server directory that has not been deleted.
3. Delete the SQL server-related keys in the registry. Then run the installer. When the above prompt appears, execute the above registry key to delete.
Also, the SQL server-related keys in the registry include:
HKEY_CURRENT_USER/Software/Microsoft SQL Server
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft SQL Server
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/MSSQLServer
All microsoft SQL SERVER and MSSQLSERVER are deleted!