Patching for Standalone SQL Instance

Implementation

Before patching change window below steps need to perform

  1. Log Onto the Standalone SQL Windows box.

Connect to sql Instance and execute the T-SQL script below to check the patch level of current Instance:

SELECT
SERVERPROPERTY('Edition') AS 'Edition',
SERVERPROPERTY('ProductVersion') AS 'ProductVersion',
SERVERPROPERTY('ProductLevel') AS 'ProductLevel',
SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime',
SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion'

2. Validate by checking if there are any Missing of msi and msp files . Please go through below link and find out missing files to fix it

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

                                                                                  OR

The tool we used is MSI-Moksha.exe  to find out missing of msi and msp files ,also by using this tool we can repair missing files itself .

  1. Repair the missing files If there are any.
  2. And we need to make sure that all above steps are completed successfully.
  3. During maintenance Window perform below steps :
  • Put SQL windows box into maintenance mode
  • Run the patch executable
  • Make sure all rules have passed or else take required actions to fix.
  • click on enabling the check box Accept the license term on next page and proceed
  • Enable the check boxes to Select all required SQL server features that needs to be Upgraded
  • Wait till Files in use will be checked, hit next when checking complete
  • Wait until the list of features will be upgraded and click on Upgrade
  • Wait until it completes and make sure it’s successful. See the error log Summary. txt located at Drive:\Program     Files\Microsoft SQL Server\100\Setup Bootstrap\Log and check the logs detail for troubleshooting when failure   happens
  1. Reboot SQL window box if required
  2. Perform SQL Health check
  3. Once above steps are completed successfully you can remove the SQL Box from MM(Maintenance Mode).

SELECT
SERVERPROPERTY('Edition') AS 'Edition',
SERVERPROPERTY('ProductVersion') AS 'ProductVersion',
SERVERPROPERTY('ProductLevel') AS 'ProductLevel',
SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime',
SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion'

Back-Out Plan :

If any issues with Patching perform below steps

Log onto Standalone SQL windows box

  • Go to Run and Open appwiz.cpl ,Program and Features window will be opened
  • On the Left Side you will see View Installed Updates or Show Updates box click on it .
  • Go down the page and locate (Sp info), check the box to mark it and hit remove
  • click next until the feature is completely removed
  • Reboot if required
  • Perform SQL Health check.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.