SQL Server patching and Fixing Missing MSI and MSP files issue
I know by looking at this article name many of you already
might think that is well known issue and addressed on below MS Link.
https://support.microsoft.com/en-us/help/969052
However in this article I will describe an interesting new
way I came across in recent past. Which I found be better and easy way as this uses a GUI tool.
Recently one of my friend found this interesting tool and
shared details with me. I thought why to stop with me and here is this article.
In this article we will see how easily FixSQLMSI.exe can fix
Missing MSI and MSP files issues. This tool is engineer name “Simon Su” and
available on below GitHub link.
Please find how to use steps below:
1. Download the package from above link.
2. Execute the exe.
3. Select the SQL Server Install path and click scan.
4. It will check for both Missing MSI, MSP files and any
miss matched files (missed matched files would be shown if you have cached any
wrong files in installer folder)
5. Once scanning is done check for Status and Action columns
to find and fix any issues. You will find many more details like Source path,
command to fix and so on.
6. If you have any missing files, click on Fix It button, if
source path is intact it will fix automatically if not it will ask for source
path, please provide the same to fix automatically.
7. Once you are done you may select log button to generate
log and share details.
8. More detailed document is published by author as part of
attached link you may check the same.
It is better to use this exe all the times before you patch
or if you find any issues while patching any SQL Server instance.
Note: this is just a guide that might help you. Please take
your own decision to use it or not.
No comments:
Post a Comment