Solved

Installing SQL Server SP2 update remotely

Posted on 2007-04-03
5
225 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 500 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
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 …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

735 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