Can we downgrade SQL database version

[Former Member]

Hi,

Currently we are using MSSQL 2008 R2 Enterprise Edition - 64bit in our SAP ECC 6.0 box. Will it possible to downgrade sql version from MSSQL 2008 R2 Enterprise Edition - 64bit to SQL Standard Edition in our SAP ECC 6.0 box. Will it supprot SQL standdard edition.

Could you please help us on this.

Thanks ina dvance.

Regards,

Malli.

[Former Member]

Quick and easy:

NO. You need the Enterprise Edition.

This is not to punish customers but it's simply required as the netweaver stack uses database features which are not available in other editions.

[Sriram2009]

Hi Mallik

MS Sql Standard version will not support for SAP system. it will support only MS Sql Enterprise version. so you may not downgrade the MS Sql.

You can refer the SAP Note for MS SQl FAQ Q10

555223 - FAQ: Microsoft SQL Server

BR

SS

[Former Member]

All supported SQL Server versions are tested by SAP in the Enterprise Edition only. Therefore, only the Enterprise Edition is supported. The SAP support may not be able to solve problems that occur with other editions.

Refer the below note:

62988 - Service packs for MS SQL Server

regards,

pavan

[mohitsahu]

Hello Mallik,

As far I know, If you have a database backup file from a 2008 R2 version, you cannot under any circumstances and with any tricks or tools restore that into a 2008 version. Just cannot be done. You will get attached error.

You need to either find a way to do this using scripting (e.g. script out the SQL structure and/or data), or you could use a structure/data comparison tool like Red-Gate SQL Compare and Red-Gate SQL Data Compare to compare two databases. With Red-Gate's tools, you can also compare a live 2008 database against a 2008 R2 backup file and move data between them.

Regards,

Mohit