Monday, August 7, 2017

Restore Missing .msi and .msp files - SQL Server

1. Download vb script from below site.

https://support.microsoft.com/en-us/help/969052/how-to-restore-the-missing-windows-installer-cache-files-and-resolve-p

To resolve these problems by using a script, follow these steps:
  1. Locate the directory to which you saved the script content.
  2. Open an elevated command prompt to the directory to which you saved the script, and run the following command:
    Cscript FindSQLInstalls.vbs %computername%_sql_install_details.txt
  3. Open the file from step 2 in a text editor such as Notepad, and identify the problems that are causing the failure. To do this, search the text file for string patterns such as the following:
    • do not
    • !!!
  4. Based on the results in step 3, take the steps that are required.

    Note Look for more information about these steps in the "Examples" section.
  5. Repeat steps 2 through 4 until the text file that is created in step 2 no longer contains text that references invalid paths or missing files for the component that is being updated.

You will have to copy either RTM install or SP1 or SP2 or SP3 install depends upon error message. If you need help please let me know.


0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home