Implementation
Before patching change starts you need
to perform below steps :
1. Log Onto Nodes N1,N2 and N3 in the cluster
2. Check for Missing msi and msp files . Please check
below link how to find out missing files and fix it
https://support.microsoft.com/en-in/help/969052/how-to-restore-the-missing-windows-installer-cache-files-and-resolve-p
OR
You
can use MSI-Moksha.exe tool to find out missing msi and msp
files ,also you can repair the missing files by using this tool itself .
3. If
there are any – repair the missing files.
4. And
Make sure that above steps are completed successfully.
5. During maintenance Window perform below steps :
·
Put Node 1 N1 into
maintenance mode
·
Log into passive node
xxx
·
Failover SQL instances,
if any, off of Node1 to any other node
·
Run the patch executable
·
Make sure all rules have
passed. If not take corrections
·
Accept the license term
on next page and proceed
·
Select all SQL server
features that needs to be Upgraded
·
Files in use will be
checked on next page – hit next when checking complete
·
Verify the list of
features that will be upgraded and hit Upgrade
· Wait until it completes and make sure
it’s successful. See the Summary. txt error log located at C:\Program Files\Microsoft
SQL Server\100\Setup Bootstrap\Log and check the detail logs for
troubleshooting if failure happens
6.
Reboot Node 1 if required
7.
Log on to Node 2 N2 and failover all
instances that exist on this node to other nodes
8.
Repeat steps 1- 9 for each Node- N2
and N3
9.
Do manual failover to move instances
to preferred node. OR if you have any automation to move instance to preferred
node RUN that.
10.
Once above steps are completed
successfully you can remove the Nodes from MM(Maintenance Mode).
11. Validate
in the Monitoring Tool ( if you have any ) to make sure the corresponding
Patched Instances are being correctly monitored.
Once above all steps are
completed successfully Connect to
SQL Instances that were patched and run below SQL to see SQL
Version is at correct level:
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 all nodes of the cluster
- On each node do the following
- Open Add and Remove Programs from control panel
- Check the Show Updates box on add remove programs window
- Go down the page and locate (Sp info), check the box to mark it and hit remove
- Follow the wizard until the feature is completely removed
- Reboot if required
- Do manual failover to move instances to preferred node. OR if you have any automation to move instance to preferred node RUN that.
No comments:
Post a Comment