SQL Server Pending File Operations Bug
When re-installing SQL Server 2000 today I came across this weird error message, saying:
A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup.
I restarted twice but the message just kept on coming. After a little snooping, I found there was (luckily) a simple fix for the problem.
- Run the Windows Registry Editor
- Surf to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SessionManager
- Delete the pendingfilerenameoperations key
Then re-start the SQL Server installation and it should work. As always, keep a backup of your registry before you touch it.