SQl Server\Windows Update \OS patches, etc., via Terminal Server Session
-
The only "downtime" we have available for patching our servers is Saturday\Sunday . In the past I have come in to patch the servers, in person.What is the general feeling about applying patches -- from Windows Updates, OS Service Packs, SQL Service packs, etc -- from a Terminal Server session? Is it a great way to go or asking for trouble?
TIA,
Bill
-
I patch all our servers via Terminal Services session. Generally this is done during the day with a reboot performed as a scheduled task.
Haven't had any adverse problems yet.
--------------------
Colt 45 - the original point and click interface
-
Same here, we occasionally get some software that can't be installed if TS is enabled but even then there are ways around it.
Just about everything we do (admin wise) it via TS and i've never come across a problem.
-
In an previous life, I supported about 130 servers running SQL Server and the only way I installed and upgraded was via Terminal Services ( or other tools on older NT4 servers). There were some issues with some software but none that I can recall with SQL. As a matter of fact, the only trouble I had was that I also did most of the installing from a network share. Terminal Services, network shares and a WAN could leave you high and dry in the middle of an install if you had network issues. I started copying the installs local to any server that might experience network issues in the middle of the install. If I got kicked out of TS while installing, my session usually kept running and I could log back in and reconnect to my session. I've used VPN from home to connect to servers at home office, where I would TS to Asia and do installs in the wee hours of the morning so as to perform them at a local requested time (when their support was in the office). Of course the installs were copied local a day or two earlier before attempting this.
I'm in a much smaller environment now but still use TS for convenience.
-
We use RDP exclusively. Whether in the office or out of the office. Our only trips to the server room are for vendors, hardware installations/upgrades ans SAN maintenance/upgrades. The only known issue I am aware of is that if you are using SQL v7.0 RDP is not supported (but PC Anywhere works in this instance).
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply