Upgrade MS SQL 2005 to MS SQL 2008 (R2) for High-Availability SAP ERP System

[Former Member]

Hi,

We are having ECC 6.0 SR3 Hight-Availability system on windows cluster environment.

Our platform is Windows Server 2008 SR2  with MS SQL Server 2005 SR3. We have two nodes in our windows cluster. Active-passive nodes.

Node-1 is having CI, ASCS, ERS & DATABASE

Node-2 is having DI, ERS & stand-by database software.

I've check all the pre-requisites for sql upgrade.

our kernel is on 700_Rel. I'm planning to stabilize the kernel with 721_Rel before Database upgrade.

Support package patch level condition is met for sql upgrade in our scenario.

Now we are planning to upgrade our MS SQL Server from 2005 sr3 to MS SQL Server 2008r2.

Please provide me the steps for Kernel upgrade and sql upgrade to 2008r2 on Windows cluster environment.

Thanks

Venkat

[Sriram2009 · Accepted solution]

Hi Venkat

1. Could you share your ECC support package level & also you can check the PAM

2. Yes you can upgrade the MS Sql to 2008 R2, before starting upgrade Kindly ensure the full OS / DB level backup on both cluster node's

3. MS Sql 2008 R2 upgrade refer the SAP Note
1152240 - Setting Up Microsoft SQL Server 2008 (R2)

4. For Kernel upgrade its release change kindly go thru the SAP Notes

1713986 - Installation of kernel 721 (EXT)

1728283 - SAP Kernel 721: General Information

1726899 - 721 DCK: Upgrade from 7.0n to 7.1n

BR

SS

[Former Member · Accepted solution]

Hi Sriram,

Our ERP 6.0 Ehp3 system  basis patch level is 23. SAPKB70023

Is there any problem if I go with 721_Rel instead of 721_ext_rel? or Should I be using 721_ext only?

I forgot to mention that I've done test upgrade on sand box with central system option. Successfully upgraded the Database. I used 721_Rel kernel then I got one dump ddic_typeleng fixed by applying snote.

can you provide ms sql upgrade steps on windows cluster server 2008 sp2?

I've standard sql upgrade document also. I'm looking for document like this: http://scn.sap.com/docs/DOC-15241

But it is on non-high-availability system. 

As I mentioned earlier all the conditions are met. Need steps for sql server 2008r2 upgrade on cluster?

Thanks

Venkat 

[Sriram2009 · Accepted solution]

Hi Venkat

1. For kernel use 721_ext (Not on 721)

2. For MS Sql 2008 R2 upgrade steps you can follow the link and refer the SAP Note

1494740 - SAP system migration from Windows 2003 to 2008 (R2) 64-bit

Microsoft link

http://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&uact=8&ved=0CC4QFjAC&url=ht...

Regards

Sriram

[Reagan · Accepted solution]

If you have a supported OS and DB then you may go for the latest version the kernel.

For MSSQL upgrade read this guide.

https://websmp101.sap-ag.de/~sapdownload/011000358700000646212013E/sql2008r2_upgrade_v150.pdf

Regards

RB

[Former Member]

Dear All,

Our production system upgrade has been completed successfully.

Once again thanks to all for your great support.

Thanks & regards

Venkat