Apply Service Pack 2 / Service Pack 3

Question

Apply Service Pack 2 / Service Pack 3

2Tall

SSChampion

Points: 14644
More actions
March 3, 2010 at 2:31 pm

#230457

Hi. I am running SQL Express 2005 9.00.3042.00. This build equates to:
2005 'Fixed' SP2 (use this if SP2 was NOT applied yet - orig. RTM removed)
SQL Express houses our AV database on a named instance.
I am scheduled to install a second instance to house a third party database tomorrow (nothing like leaving it late) 🙂
I would like to apply SQL Services packs 2 and 3. Can I jump straight to SP3 or would the reccomended upgrade path be SP2 then SP3?
I have downloaded Microsoft SQL Server 2005 Express Edition Service Pack 2 (SQLEXPR32.EXE) and also
Microsoft SQL Server 2005 Express Edition Service Pack 3 (SQLEXPR32.EXE).
These appear to be the full SQL 2005 Express Editions with the service pack applied. Can I install over the top of currrent install to apply the service pack?
Many Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

I would like to apply SQL Services packs 2 and 3. Can I jump straight to SP3 or would the reccomended upgrade path be SP2 then SP3?
I have downloaded Microsoft SQL Server 2005 Express Edition Service Pack 2 (SQLEXPR32.EXE) and also
Microsoft SQL Server 2005 Express Edition Service Pack 3 (SQLEXPR32.EXE).

SQL Server 2005 Express service packs comes with the SQL Server so backup your databases and install the SP2 first because if you try to install the SP3 it may say you need to install SP2 first.

I am assuming you know the SQLEXPR32.EXE is a special binary for x64 operating system install because SQL Server 2005 Express comes only in x86.

Kind regards,
Gift Peddie

2Tall SSChampion Points: 14644 More actions · Answer 2

Hi Gift. No I did not know that. Are you saying I update using the standard SQL service packs that I would apply to the full version of SQL? I did not think they were applicable to Express?

I downloaded what is thought was the correct version from here:

Note: To upgrade SQL Server 2005 Express Edition, obtain the SP2 version of Express Edition or Express Edition with Advanced Services.

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

Thanks,

Phil.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

I think that link is for the standard SQL Server 2005 SP3 because here are the Express SP2 and SP3 download links.

http://www.microsoft.com/downloads/details.aspx?familyid=31711D5D-725C-4AFA-9D65-E4465CDFF1E7&displaylang=en

http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-acdd-9a1c832e65a6&displaylang=en

Kind regards,
Gift Peddie

2Tall SSChampion Points: 14644 More actions · Answer 4

Gift many thanks.

I have rolled out the install on the current version.........I will look to backup then upgrade.

Found this regards automating backups in SQL Express for those who might be interested.

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ExpressBackups&referringTitle=Home

Question I have is can I use production system Job to backup database on SQL Express instance?

Many Thanks,

Phil.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

2Tall (3/4/2010)
Gift many thanks.
I have rolled out the install on the current version.........I will look to backup then upgrade.
Found this regards automating backups in SQL Express for those who might be interested.
http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ExpressBackups&referringTitle=Home
Question I have is can I use production system Job to backup database on SQL Express instance?
Many Thanks,
Phil.

Yes you should if you turn on the browser service in both and register the Express with the production. Here is a thread with alternative tools you can use to schedule in the Express.

http://www.sqlservercentral.com/Forums/Topic401898-324-1.aspx

Kind regards,
Gift Peddie

2Tall SSChampion Points: 14644 More actions · Answer 6

Thanks Gift.

register the Express with the production

Linked server?

Thanks for all your input.

Phil.

PS: Great links.

-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

Tommy Cooper