I would like to know from some DBA's out there how you handle SQL service pack upgrades and cumulative updates? I have 70 SQL productions instances to take care of and I am the only DBA. I also have 10 SQL test instances that mimic our more mission critical systems. Basically I use the test SQL instances to manual install the service packs and cumulative updates before I install them into production.
I am trying to come up with an automated safe way to deploy the SP and cum updates to my test instances first. Is there a third party tool that I can use to schedule the install the SQL service packs and cum updates and allow me to roll back the install (painlessly) if it failed?