FAQ: Will there be a single/inline image of SQL Server 2005 + SP1?
(First in another new category of posts, taking questions I get in mail, in blog comments and from our internal support alias's and posting them back out again)
With the exception of express the answer is currently no, let me explain a little.
Historically with SQL 7/MSDE 1.0 and above we have not provided a slipstreamed(thats the term we use at Microsoft but I have heard others call it inlining, single image etc) image of the non embedded (MSDE, Express) SKUs. Its vital for the embedded SKUs as it makes it much easier for ISVs to install. The current plan is not to change that approach, although plans are subject to change.
The primary reasons for not doing it are resource cost and complexity, remember there are > 700 SKUs of SQL Server, if we slipstreamed we would add 700+ new SKUs in every SP. We know we have to ship a pure patch based solution (ie the current solution) but if we slip streamed, it would mean that each SP that followed would need its patch based solution tested against both a patched previous SP and a slipstreamed one so on and so forth. Doing this would massively increase the time required to ship an SP as the team would be struggling under the number of combos, that is already pretty huge.
Now there are alternatives we have been looking at for this going forwards, one would be a chained installer where you would start setup of the RTM bits and then all the SPs would be applied either from media or from Microsoft Update.
We actually have considered this very carefully a couple of times over the last few years, but when we map out the resources to do it, we have always backed away, however as I said plans change, feel free to comment.
Comments
Anonymous
April 27, 2006
Totally support your decision. After all, people looking after SQL Server isn't non-professional, knowing the need to patch is the first job requirement. Time should be used to build beautiful products to beat Ora%^& away. Playing X360 isn't allowed too!Anonymous
April 27, 2006
Favor a chained installer from Microsoft update.Anonymous
April 27, 2006
The comment has been removedAnonymous
April 27, 2006
SQl Consultant,
Good point, however...
SP3 was never slipstreamed into SQL2000 (other than MSDE), there was a SQL2000a version release that contained only the slammer fix, which was very very very narrow, ie a couple of lines change in one file. This was done for a couple of reasons
It was far more narrow a change than an SP, hence we felt it was valid, we also pulled the SQL2000 media after that so you could only get the "a" version, although it was not all removed from the channel, hence we did attempt to reduce the number of SKUs as part of this.
In the case of that fix we had to, it was difficult in orgs where slammer existed to get a SQL Server RTM up and running without it becoming infected becase the SSRP process comes online fairly early in the setup.
It was also simply the right thing to do.
I should be clear however, this is not a technology problem, you are right it can be done, and we do it for Express, it is resources as I said.Anonymous
April 27, 2006
The comment has been removedAnonymous
April 27, 2006
Even if you're not planning on shipping SP1 pre-slipstreamed, is it possible for us to slipstream the patch ourselves onto our install source, to allow for easier deployments?Anonymous
April 27, 2006
SQL Consultant,
Humble submission accepted, and you would not be the first.
Dave,
Yes you can just do the chaining yourself as long as you wrap the installer in some way. Call the RTM installer with switches and then the same for the SP1 installer.Anonymous
April 27, 2006
it would be perhaps good if MS could provide (say in a kb) a robust example of how to script this in a say batch file. ie with error checking that handles dependencies - ie if RTM doesn't install then drop out , if sp1 fails give option of rolling back (ie go de-install) pausing (ie fix up the problem) or quitting
cheers,
AndyAnonymous
April 28, 2006
I truly think MS have missed a step with the install of SP1. The install for RTM inroduced side by side...Anonymous
April 30, 2006
Andy,
Good suggestion I'll see what we can do.Anonymous
May 04, 2006
I understand what you're saying about the number of SKUs, but doesn't this same concern exist with respect to the various OSes?
We do have the ability to slipstream with them as well as order already slipstreamed CDs (such as Windows Server 2003 SP1). We can chain hotfixes from the slipstreamed install. Both of these together greatly reduce the amount of time an administrator takes to bring a system online but what really makes up the difference is that slipstream of the service pack.Anonymous
May 09, 2006
Brian,
Yes the same concern does exist with OS's but it is also slightly different fo some of the same reasons we did 2000a, these also apply to Windows. To be clear its not that we can't do it, right now we have chosen not to, having looked at the trade offs. One of the reasons for starting this thread is because I wanted to see how people felt about the issue, well now we know :-)Anonymous
May 09, 2006
Slipstreaming Windows patches has proven to be a huge plus, and I'd even say, essential in a large environment. The same should be true for SQL Server.
We've been asking for slipstreaming SQL patches/SPs for as long as I can remember to no avail. The alternative of using a wrapper install script is just not robust enough. But since we are not going to get slipstreaming, I support Andy's call for a Microsoft supplied sample, but robust, install script that installs both RTM and SP1.
SGAnonymous
May 12, 2006
The comment has been removedAnonymous
May 22, 2006
I truly think MS have missed a step with the install of SP1. The install for RTM introduced side by side...Anonymous
May 23, 2006
There seems to be multiple points that seem to be in contradiction to a chat last year. At that time, Maxwell Myrick indicated that it was a design goal to allow slipstreaming for SQL 2005. It also says that there will be a MSDE version of 2000 that will have SP4 slipstreamed into it. Both things you have said either won’t happen for SQL 2005 and didn’t/won’t happen for MSDE 2000.
Actually “Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A” includes sp3a “slipstreamed” into it. This is according to the readme included with the download for MSDE 2000 Release A.
Slipstreaming was one of the "features" that I was looking forward to in SQL 2005. Now it seems that it will not be happening after all. Too bad, with it you know your new installs will always have the current patches/service pack regardless if a developer with no DBA experience is installing them or not (we still have issues with developers using a blank sa password).
Below I have included the references and extracts from the sources I mentioned.
http://www.microsoft.com/technet/community/chats/trans/sql/05_feb15_sql.mspx
Max (Expert):
Maxwell Myrick is a Program Manager Lead with SQL Server at Microsoft. He is currently responsible for the servicing release team. He was also the release manager for SQL Server SP3a / MDAC 2.71 refresh. Some of you may also remember him as the SQL Customer Lab manager from Aug 2000 through Feb 2003.
Max (Expert):
Q: Will there be a Slip streamed SP4 Install package for SQL 2000 to ease the installation of SQL 2000 on Windows 2003?
A: There will NOT be a slipstreamed version of SQL 2000 SP4 - except for MSDE per usual. SP4 is still Installshield-based as was our original SQL Server 2000 product. SQL Server 2005 (aka Yukon) will be MSI based and we are working to provide slipstream SPs on that platform thanks to the benefits of MSI. MSDE users will have a full version (SQL 2000 + SP4) for their MSDE installation in both MSM and MSI format.
http://download.microsoft.com/download/d/5/4/d5402c33-65de-4464-9d82-d1de2971d9db/ReadmeMSDE2000A.htm
MSDE 2000 Release A contains the same fixes as MSDE 2000 SP3a , including those that address issues raised by the Slammer worm. You do not need to apply MSDE 2000 SP3a to MSDE 2000 Release A, or to upgrade MSDE 2000 SP3a or SP3 to MSDE 2000 Release A.Anonymous
May 23, 2006
The comment has been removedAnonymous
June 09, 2006
When rolling out servers I can usually bear the overhead of applying SPs manually, albeit reluctantly. The biggest headache I have is rolling out client tools to hundreds/thousands of developers/users then applying the SPs, either slaughtering a WSUS server or the link to Microsoft Update.Anonymous
January 01, 2007
Welcome to 2007! As seems to be the trend here is the list of most popular posts for the last year, IAnonymous
January 06, 2007
The comment has been removedAnonymous
August 10, 2007
The comment has been removedAnonymous
August 11, 2007
I truly think MS have missed a step with the install of SP1. The install for RTM introduced side by side