Does SQL Express support upgrade from MSDE2000 Chinese Edition?

I've tried to download the sql express and install, but it doesn't allow me to select upgrade the default instance (which i've installed msde2000 chinese edtion), it told me due to the language problem, sql express can't upgrade the default instance and only could install sql express in new instance.

I have no idea for the language edition for sql express since the download page doesn't have a language selection.

So does anyone know that,
1. would sql express have multi language edtion ?
2. if sql express would have one language edtion, how could install it to upgrade from one existing msde2000 simplified chinese edtion ?Upgrading across languages is not supported. If you want to upgrade your Chinese databases you'll need to wait until the Chinese edition of Express is released. The currently released version of Express is English only.

Does SQL 2005 in-place upgrade update all nodes?

We have a two node, single instance SQL Server 2000 cluster. If I do an
in-place upgrade to 2005, will it replace the binaries on both nodes, or must
I run the upgrade on each node?
Yes and No.
The SQL storage engine upgrade is cluster aware and will update all nodes
(assuming all nodes are online and working at the time of the upgrade). The
tools installer is NOT cluster aware and will have to be run on each node
independently. Personally, i prefer to load the tools first and then go
back and upgrade the engine.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"steveg" <steveg@.discussions.microsoft.com> wrote in message
news:963FDCFA-1752-4DBA-AA29-CAC4CFFDD705@.microsoft.com...
> We have a two node, single instance SQL Server 2000 cluster. If I do an
> in-place upgrade to 2005, will it replace the binaries on both nodes, or
> must
> I run the upgrade on each node?
sql

Does SP4 client work OK with SP3a server?

Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server?
We are planning on updating all the client pcs to SP4 before we upgrade the
servers.
Thanks
Rondid you hear examnotes <Ron@.discussions.microsoft.com> say in
news:0D2D4D7E-7BAF-4600-A545-0B2FB6E82291@.microsoft.com:

> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a
> server? We are planning on updating all the client pcs to SP4 before
> we upgrade the servers.
> Thanks
> Ron
I have a mix of 3a and 4 and my client db libs are 4. you should be ok.
(My 2)
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||You won't be able to use Query Analyzer's debugger against the SP3a
servers. In SP4, Microsoft upgraded the debugger to use the .NET
framework. Other than that, there should be no problems.
Josh
Ron wrote:
> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server
?
> We are planning on updating all the client pcs to SP4 before we upgrade th
e
> servers.
> Thanks
> Ronsql

Does SP4 client work OK with SP3a server?

Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server?
We are planning on updating all the client pcs to SP4 before we upgrade the
servers.
Thanks
Rondid you hear =?Utf-8?B?Um9u?= <Ron@.discussions.microsoft.com> say in
news:0D2D4D7E-7BAF-4600-A545-0B2FB6E82291@.microsoft.com:
> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a
> server? We are planning on updating all the client pcs to SP4 before
> we upgrade the servers.
> Thanks
> Ron
I have a mix of 3a and 4 and my client db libs are 4. you should be ok.
(My 2¢)
--
Neil MacMurchy
http://spaces.msn.com/members/neilmacmurchy
http://spaces.msn.com/members/mctblogs|||You won't be able to use Query Analyzer's debugger against the SP3a
servers. In SP4, Microsoft upgraded the debugger to use the .NET
framework. Other than that, there should be no problems.
Josh
Ron wrote:
> Can a SQL2000 SP4 client connect without problems to a SQL2000 SP3a server?
> We are planning on updating all the client pcs to SP4 before we upgrade the
> servers.
> Thanks
> Ron

Does MS SQL 2000 support multiple processors?

We are in the process of moving our SQL servers to a SAN
environment and decided to upgrade our servers to 4
processors. Therefore, does anyone know if MS SQL 2000
supports multiple processors?Depends on the edition. See BOL: Maximum Capacity Specifications for the
complete OS\Edition matrix. For four processors, you can use any of the
Windows Server OS editions and Standard or Enterprise Edition SQL Server
2000.
From the performance side, SQL does very well with multiple processors.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Cory" <crubicco@.yahoo.com> wrote in message
news:04ae01c3883d$882e63b0$a301280a@.phx.gbl...
> We are in the process of moving our SQL servers to a SAN
> environment and decided to upgrade our servers to 4
> processors. Therefore, does anyone know if MS SQL 2000
> supports multiple processors?

Does In-place upgrade set compatibility level to 9.0

This may be very obvious and when I get to the first test server I will find out, but I only have a new installation of SQL2K5 so far to test with. I have several databases that need to be upgraded to run on 2K5, but the application requires them to run in 8.0 compatibility. Does this mean that an in-place upgrade is not an option?

I apologize if this is a silly question, but I have not yet found the answer specifically.

Thanks very much.

No, it does not change the compatibility level. It leaves it at 8.0.|||

So even on an in-place upgrade you still have to go to each database and manually change the compatibility level? This tells me that it only saves me the transfer or moving of the databases themselves, right?

Thanks!

|||

Saves you moving databases, having to export/import logins from master, jobs from msdb, etc.

But it doesn't assume you want compatibility level 9.0 -and that, in my opinion, is a good thing.

Document for In-Place Upgrade of SQL Server 2000 to 2005

Hi,

We are performing the In-Place upgrade of SQL Server 2000(enterprise) to 2005(enterprise) in a clustered environment.

The issue is that the upgrade does not proceed in case both the machines in the cluster are running.

The error shown is

Product Name : Microsoft SQL Server
Product Version : 9.00.1399.06
Message Source : setup.rll
Message ID : 50000
EvtType : datastore\clustergroupsproperties.cpp@.InvokeSqlSetupDllAction@.ClusterGroupScope.SharedDisks@.0x2

It proceeds (with some errors) only if i stop the cluster service on the other machine. It is an expected behavior?

Does anyone have the documentation for this type of upgrade? Or just the basic steps to be followed.

http://www.sqlservercentral.com/columnists/ssamuel/2987.asp

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

check these links might be helpful

|||

In virtually every case of a cluster upgrade, I always tell my clients to perform a new install and not perform an in-place upgrade. If you have this option, take it. Upgrading in place is possible, but fraught with difficulties.

|||

I would need more information on your configuration and the exact steps you are going through. I wrote the section in the upgrade documentation for upgrading a cluster. I've upgraded both single instance and multi-instance clusters, in place, without any of the issues you are mentioning.

Document for In-Place Upgrade of SQL Server 2000 to 2005

Hi,

We are performing the In-Place upgrade of SQL Server 2000(enterprise) to 2005(enterprise) in a clustered environment.

The issue is that the upgrade does not proceed in case both the machines in the cluster are running.

The error shown is

Product Name : Microsoft SQL Server
Product Version : 9.00.1399.06
Message Source : setup.rll
Message ID : 50000
EvtType : datastore\clustergroupsproperties.cpp@.InvokeSqlSetupDllAction@.ClusterGroupScope.SharedDisks@.0x2

It proceeds (with some errors) only if i stop the cluster service on the other machine. It is an expected behavior?

Does anyone have the documentation for this type of upgrade? Or just the basic steps to be followed.

http://www.sqlservercentral.com/columnists/ssamuel/2987.asp

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

check these links might be helpful

|||

In virtually every case of a cluster upgrade, I always tell my clients to perform a new install and not perform an in-place upgrade. If you have this option, take it. Upgrading in place is possible, but fraught with difficulties.

|||

I would need more information on your configuration and the exact steps you are going through. I wrote the section in the upgrade documentation for upgrading a cluster. I've upgraded both single instance and multi-instance clusters, in place, without any of the issues you are mentioning.