Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Installing SQL Server SP2 update remotely

Posted on 2007-04-03
5
Medium Priority
?
228 Views
Last Modified: 2013-11-21
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.
0
Comment
Question by:Rohidas357
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 11

Accepted Solution

by:
AnthonyP9618 earned 2000 total points
ID: 18847388
Rohidas357,

The SQL Server SP2 install (I assume were talking 2005 right?) is pretty straight-forward, so you shouldn't hit any snags.  That said, SP updates are pretty lengthy and sometimes complex and can cause some serious problems if the correct steps aren't taken (e.g., make sure you check your backups!!).  I would probably recommend that you do a combination of both.  Wait until Sunday to do it, but do it remotely.  This way if something DOES happen you have the time and ability to drive there and fix it on-site.
0
 

Author Comment

by:Rohidas357
ID: 18847680
That actually sounds like an excellent suggestion. Would you mind elaborating a bit about your reference to backups? I was certainly going to make sure I backed up all the databases before performing the upgrade, but are there specific ways to check the backups to make sure they are viable?
0
 
LVL 11

Expert Comment

by:AnthonyP9618
ID: 18847702
The best test would involve setting up a new SQL Server instance and restoring the backed up databases to that new server.  If that's not possible, you could always rename the backup database files and attempt to restore them back into the same SQL Server instance.  Either way, you want to ensure that all the data is captured in the backup before proceeding.

This Technet article goes through the backup procedures.. It really relates to WSS, but a lot more to SQL Server in general: http://technet2.microsoft.com/windowsserver/WSS/en/library/2a005b70-2f53-42a1-89e0-f907a8e986231033.mspx?mfr=true
0
 

Author Comment

by:Rohidas357
ID: 18847807
Thank You!
0
 
LVL 11

Expert Comment

by:AnthonyP9618
ID: 18847820
Good luck... Although I think you should be fine!
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question