I have to install the Service Pack 3 on an SQL instance running with the SP1. No test, the install is directly on the production server. Well this is not a complex task and the topic has been already ask for other version, but I'd like to be sure to not forget some steps and having feed back from experienced dba is always welcome. Here my custom planned checklist :
1.list all bugs that have been addressed in the Service Pack. ie:https://support.microsoft.com/en-us/kb/2509302
2.Take a virtual machine backup and backup all the databases.
3.Disable SQL Server agent.
4.Apply the Sp.
5.Restart server/instance if needed.
6.Check for the Service Pack level of the SQL Instance.
7.Check for all entries in SQL Server Error Log about the Service Pack update and ensure there are no errors written.
8.Refering step N°1, check for eventuals bug issues.
9.Enable SQL Server Agent.
From the client side :
- Check for any compatibility problem between his software and the SP3.
- After the install, check for client connectivity between DB/software.
Is there any step you'll find pertinent to add/remove/modify to this ?