Minimun SP Level for Cluster Upgrade

I'm upgrading MSSQL2000 (RTM) cluster to 2005. I haven't seen any information regarding a minimum service pack level for 2000. This upgrade just makes me overly caution.

To upgrade to SQL 2005, you need to be running SQL 2000 SP3(or SP3a) at a minimum.

Thanks,

Sam Lester (MSFT)

|||

Here's the link from Books Online:

http://msdn2.microsoft.com/en-us/library/ms144245.aspx

Sam

minimun installation

I need to reduce de installation pack of sql server express 2005. how
can i do that?
thanks.AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

I need to reduce de installation pack of sql server express 2005. how
can i do that?

I'm afraid that I don't really understand the question. Do you want remove
compenents from your installation?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog ha escrito:

Quote:

Originally Posted by

AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

I need to reduce de installation pack of sql server express 2005. how
can i do that?

>
I'm afraid that I don't really understand the question. Do you want remove
compenents from your installation?
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

size of SQL Server Express distrubition files is 180 MB, i want to
reduce this size. I need to make the possible smallest distribution.
Thanks for the answer.|||On 24 Aug 2006 03:31:28 -0700, "AKS" <dagato2@.terra.eswrote:

Quote:

Originally Posted by

>
>Erland Sommarskog ha escrito:
>

Quote:

Originally Posted by

>AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

I need to reduce de installation pack of sql server express 2005. how
can i do that?

>>
>I'm afraid that I don't really understand the question. Do you want remove
>compenents from your installation?
>>
>>
>--
>Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>>
>Books Online for SQL Server 2005 at
>http://www.microsoft.com/technet/pr...oads/books.mspx
>Books Online for SQL Server 2000 at
>http://www.microsoft.com/sql/prodin...ions/books.mspx

>
>size of SQL Server Express distrubition files is 180 MB, i want to
>reduce this size. I need to make the possible smallest distribution.
>Thanks for the answer.

These days, if 180 MB was a concern, I would expect to find myself
dealing with either (1) a nickel-and-dime client that wasn't worth
my time anyway, or (2) an embedded system (in which case I would
look into SQL products specifically designed for embedded systems).|||AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

size of SQL Server Express distrubition files is 180 MB, i want to
reduce this size. I need to make the possible smallest distribution.

I'm not into redistribution of SQL Express myself, but I note that the
download file for SQL Express is 55 MB. But you probably have to include
..Net Framework 2.0 as well, which is another 22 MB.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||i know it, but when you extract files with option /x, it will be 180
MB, without .net framework. I need install database with another
application, so i need to reduce 180 MB, is it possible?.

Erland Sommarskog ha escrito:

Quote:

Originally Posted by

AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

size of SQL Server Express distrubition files is 180 MB, i want to
reduce this size. I need to make the possible smallest distribution.

>
I'm not into redistribution of SQL Express myself, but I note that the
download file for SQL Express is 55 MB. But you probably have to include
.Net Framework 2.0 as well, which is another 22 MB.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

i know it, but when you extract files with option /x, it will be 180
MB, without .net framework. I need install database with another
application, so i need to reduce 180 MB, is it possible?.

Why would distribute the whole thing expanded? Is there any reason why
you would not distribute your own setup files of which SQLEXPR.EXE is a
part? If nothing else, just put the thing in a ZIP archive.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||icant do it, i have to customize de sql installation and this can not
be interactive with user( silence installation ). And i have to call
sql setup from other setup. Sql will be part of another aplication.

Erland Sommarskog ha escrito:

Quote:

Originally Posted by

AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

i know it, but when you extract files with option /x, it will be 180
MB, without .net framework. I need install database with another
application, so i need to reduce 180 MB, is it possible?.

>
Why would distribute the whole thing expanded? Is there any reason why
you would not distribute your own setup files of which SQLEXPR.EXE is a
part? If nothing else, just put the thing in a ZIP archive.
>
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||AKS (dagato2@.terra.es) writes:

Quote:

Originally Posted by

icant do it, i have to customize de sql installation and this can not
be interactive with user( silence installation ). And i have to call
sql setup from other setup. Sql will be part of another aplication.

And that was essentially what I said: integrate your SQLEXPR.EXE in
your setup.

I'm sorry, I can't assist with any details, because I don't work with
Windows Installer (or any other installer). But it is quite clear to
me that there is no need to distribute the SQL Express installation
expanded into 180 MB. If Microsoft can distribute it 54 MB, so can you.

It's possible that you can remove some files from the SQL Express
installation, but I seriously doubt that you can slash it to 54 without
compressing it, one way or another. After all, once you've extracted
the exe-file, right-click and select Add to Zip file. Don't tell me
you cannot that.

You should probably investigate if you can find a forum devoted to
Windows Installer, so you can get some tips on building your setup.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||To beat this dead horse a little more, I looked what it's in the extracted
install file, and while it's possible that you could remove some files
for documentation or tools, there is not much to win. Besides installation
would surely fail.

The two largest file in the pack are mssqlsystemresource.mdf and
sqlerver.exe and together they account for more than the full SQLEXPR.EXE.
And few files are more essential than these two...

So you need to learn how to incorporate SQLEXPR.EXE in your setup.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I think it too. Thanks for all.

Erland Sommarskog ha escrito:

Quote:

Originally Posted by

To beat this dead horse a little more, I looked what it's in the extracted
install file, and while it's possible that you could remove some files
for documentation or tools, there is not much to win. Besides installation
would surely fail.
>
The two largest file in the pack are mssqlsystemresource.mdf and
sqlerver.exe and together they account for more than the full SQLEXPR.EXE.
And few files are more essential than these two...
>
So you need to learn how to incorporate SQLEXPR.EXE in your setup.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

sql