i am looking for DBA that can help me to create procedure that would describe what needs to happen before and after MS SQL Server patching. My goal is to creat guidance for IT patching team so they can follow procedures before and after restarting SQL server. For example,
1. Execute backup.
2. Make sure all sql transactions are closed
3. Check services status.
4. Execute script to stop sql services
Can you please assist?
Perhaps, you have established this kind of process in your organization that works and you can share it.