Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have been wracking my brain over upgrading sql server 2005 to sql server 2005 sp4. I have a script for installing new instances of sql servers for all versions and they all work wonderfully. Problem is, sql server 2012 can't upgrade sql 2005 SP3 and below. So, I have to install up to sql 2005 SP4, AND THEN upgrade through sql 2012, which is highly annoying.

I need to do this silently via the command line, but I cannot get it to work at all. Here are some samples I tried:

 "SQLSP4.exe /qb /ACTION=Upgrade /INSTANCENAME="FOOBAR""
 "SQLSP4.exe /quiet /instancename="FOOBAR""

among a couple other variations. I could not find anything online at all. In fact, the one helpful thread ended in saying that Microsoft didn't have any support for this, but I'm not sure about that.

What can be done here? Does anyone have any experience in updating service packs via command line?

share|improve this question
Oh ok, didn't know that existed, sorry. Can this be migrated? – Cerealkiller050 Mar 6 at 22:41
Yes, but I cannot do it myself, and I don't know how to request it. I can vote to close it with a recommendation to migrate it to there, or you could re-post it. – RBarryYoung Mar 6 at 22:44
OK, I figured out how to request a Moderator to move it... – RBarryYoung Mar 6 at 22:46

migrated from stackoverflow.com Mar 8 at 5:47

1 Answer

up vote 0 down vote

Here's what I've used when updating SQL 2005 to SP4 but I was updating all insances so you might need to adjust if you have multiple instances on a server and only want to update one. \\fileServer\SQL2005\SPs\SQLServer2005SP4-KB2463332-x64-ENU.exe /quiet /allinstances

share|improve this answer
I tried this line and it worked to a point. However, it will come to the "following components are being configured" and it doesn't list any instances. I do have an instance running from a previous sql 2005 version, but it just isn't seeing it somehow. Any ideas? – Cerealkiller050 Mar 7 at 16:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.