Installing SQL Server SP2 update remotely
Posted on 2007-04-03
I need a bit of advice. I run a SQL server that hosts patient billing software that is accessed by our 12 health care centers via Terminal Services. The SQL server has never been updated, and I want to install SP2 on it. Since I am about 75 miles away from the physical server, and since the clinics are open from 8:30 am to 7:30pm M-F and on Sat., I would prefer to install SP2 after hours from home via my remote desktop connection. I am somewhat nervous about doing it this way, however, since I understand that if something goes wrong with the update, I cannot just roll back the SP2, I would have to reinstall the whole SQL server. If that were necessary, I would not be at the server to insert the required CDs. And when I recently updated our Blackberry server to SP2, there were explicit warnings not to do the update remotely.
So my question is: how risky is the install of SP2? Should I not worry about it and just install it remotely, or not take any chances and drive the 75 miles on Sunday to do it?
Any advice would be appreciated.