MS SQL 2005 clustered database instance.

[Former Member]

Short Text

MS SQL cluster database instance - ONLY!

Long Text

Hi,

If possible could you please confirm that our planned landscape

migration is supported by SAP.

At present our PRD SAP system is a standalone instance that consists of

the database & central instance running on the same "HOST".

<u>Current SAP PRD version:</u>

ERP 2004 ECC 5.0 32 bit

MS SQL 2000 32 bit

both running on same host with OS Windows 2003 32 bit

We plan to upgrade/migrate our PRD SAP system to new 64 bit hardware

AND to move to a "Distributed" landscape installation i.e. database

instance & central instance installed on different HOSTS. Also, the

database instance WILL be clustered but the central instance will NOT

be clustered. There are also multiple NON-SAP MS SQL databases that

will run in the same cluster as the PRD SAP database instance.

<u>SAP PRD version after migration:</u>

SAP ERP 2004 ECC 5.0 64bit (running on X86_64 AMD64 hardware) on HOST'X'

MS SQL 2005 64 bit (running on IA64 hardware) on clustered HOST'Y'

Both running on Windows 2003 64 bit

<u>My questions are:</u>

1) Does SAP support a clustered MS SQL 2005 database instance that is

running on a clustered HOST along with NON-SAP MS SQL databases?

2)During the migration our PRD SAP MS SQL database will be upgraded

from MS SQL 2000 32 bit to MS SQL 2005 64 bit IA64, is this also

supported in a clustered istallation (database instance ONLY)?

3) The central PRD SAP instance will be running on x86_64 AMD64

hardware & the database instance will be running on 64 bit IA64

hardware. Is this configuration supported?

Thanking you inadvance.

[Former Member]

Hi Greg,

Have you figured out the answer? We are trying do the exactly the same thing -- Move our SAP WAS 6.40 clustered central instance to a 64-bit hardware/SQL 2005/Clustered system. And this system has several non-SAP database on there. The biggest concern we have is whether SAP support this architecture. I posted a message here last year and several experts like Clas Hortien, N. P. C, in this form suggest NOT go to this architecture because SAP will not support it. One example, is that SAP/SQL requires server collation setting to SQL_Latin1_General_CP850_BIN2 and other databases may work on different collations.

Anyway, if you or anyone in this form have some more information please share here.

Thanks,

Yujun Ran

[Former Member]

Hi Gregory ,

ERP 2004 ECC 5.0 is I believe 640 kernel?

regards

Goran

[Former Member]

Hi Goran,

Correct...ERP ECC 5.0 does run 6.40 kernel.

Regards, Greg