January 20, 2009 at 7:56 am
I've had no problems applying patches to SQL Express until SP3.
I'm using the command line option SQLEXPR.EXE /quiet /allinstances (I've had to rename SQLEXPR_ADV.EXE to SQLEXPRE.EXE because our installer originally looked for this file, to install SQL)
The update will launch to GUI, requiring user input.
When I do the SQLEXPRE.EXE /? command option I get told to go to books online, which is useless for automating SQL Express SP3.
Has anyone succesfully done an automated, quiet update of SP3 for SQL Express? Thanks.
EDIT: OK, trying it with other command line switches necessary for a fresh install........let ya know how it works.
OK, so since this is not just a service pack but an upgrade I had to use this syntax:
SQLEXPR.EXE /qb INSTANCENAME=" " UPGRADE=SQL_Engine,Client_Components
January 24, 2009 at 1:00 am
Hello,
SQL Server Express edition service pack 3 is not just another SP but an actual upgrade. Even if you run the .exe, it will reinstall not just apply SP3.
[font="Courier New"]Sankar Reddy | http://SankarReddy.com/[/url][/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply