Thursday, November 22, 2012 6:02 PM
I added a new node to a SQL Server failover cluster. When i was trying to update the SQL server 2008 r2 with SP2 on the New node I got an error . All the existing nodes already have SQL Server service SP2, so the new node also needs to be SP2. I am getting the missing msi file error when applying SP2 to the new node.
SQL Server Setup has encountered the following error:
The cached MSI file 'C:\Windows\Installer\df540d0.msi' is missing.
Its original file is 'sql_engine_core_inst_loc.msi' and it was installed for product 'SQL Server 2008 R2 Database Engine Services'
version '10.50.1600.1', language 'ENU'.
To resolve this problem, recover the missing file from the installation media and start setup again.
For more information about how to resolve this problem, see 'Steps to restore the missing Windows Installer cache files' (http://go.microsoft.com/fwlink/?LinkId=144387) in the Microsoft Knowledge Base.
Error code 0x84B20002.
My questions are:
1) how do the msi files become missing? Are they deleted automatically or do they get deleted manually?
2) I have read articles online about how to resolve the problem. But what i need to know is how and why do the files get missing?
- Edited by SQLScript Thursday, November 22, 2012 6:50 PM
Thursday, November 22, 2012 6:11 PMModerator
That script will tell you what MSIs were deleted and where on the computer SQL Server setup is trying to access the original media that installed the .MSI to recreate MSI files.
This happened to me a few months ago where some of my teammates cleaned up many .MSI files and then deleted SQL Server media from a few computers.
Hope this helps.
Thursday, November 22, 2012 6:30 PM
I had spend almost two months to fix this issue last year in most of our SQL instances during SQL Server 2005 SP4 updates.
This issue occured because the msi files were deleted from the installer folder, which was a hidden system folder.
My only guess was, a clean up script was deleting older files to free-up disk space on C: drive ;)
SKG: Please Marked as Answered, if it resolves your issue. (b:http://sudeeptaganguly.wordpress.com )
Thursday, November 22, 2012 6:38 PMModerator
The bad thing about this is that once those MSI files are deleted the operating system and SQL Server instance will be on a not supported state, if you call Microsoft Support you may not receive support or they may take the case on a best effort basis.
It is sad to hear the same happen to you Sudeepta.
- Edited by Alberto MorilloMVP, Moderator Thursday, November 22, 2012 6:39 PM
Thursday, November 22, 2012 7:09 PM
Thanks for your response. I am a little suprised that the files were deleted from the new node i added to the SQL Server failover cluster. I did not run any cleanup jobs to delete old files on the new node which i recently added to the cluster
I added a new node to a SQL Server failover cluster. When i was trying to update the SQL server 2008 r2 with SP2 on the New node I got the error . All the existing nodes already have SQL Server service SP2, so the new node also needed to be SP2.
I am getting the missing msi file error when applying SP2 to the new node in the SQL server 2008 r2.
Thursday, November 22, 2012 7:25 PMModerator
That is normal. As soon as files are deleted from Windows\Installer folder servicing is no longer available. You won’t be able to apply any service pack or cumulative update on the instance.
On my experience is a lot easier to rebuild the whole node than troubleshooting those missing MSI files.
What or who could have deleted those files? Maybe a security software, a cleanup software or maybe a teammate/coworker trying to get more free space on disk.
Hope this helps.
- Marked As Answer by SQLScript Thursday, November 22, 2012 7:33 PM