SQL 2008 SP2 installation

[Former Member]

Dear Experts,

We recently under gone SAP Post go-live check. In the report SAP suggested for database patch updation.i am using standalone server,my SAP application is CRM 7. and database SQL 2008 SP1. I plan to install SQL 2008 SP2 . please answer me for the following Questions .

1) Is it really need to stop SAP application while installing SQL 2008 SP2

2) is it need to install SAP 2008 SP1 CU6 before installing SQL 2008 SP2.

let me know any steps to follow to upgrade SQL 2008 Swevice pack.

Thanks

Jyothish

[sivakumar_kilari3 · Accepted solution]

> 1) Is it really need to stop SAP application while installing SQL 2008 SP2 ........yes

> 2) is it need to install SAP 2008 SP1 CU6 before installing SQL 2008 SP2..... What is your present SQL version?.

thanks,

Siva

[Former Member · Accepted solution]

Thanks Siva,

My current SQL version is SQL 2008 SP1 64bit build 2531.

Thanks

Jyothish

[sivakumar_kilari3 · Accepted solution]

Its not mandatory to update Cumulative updates (CU). You can apply SP2 without updating CU.

Cumulative updates (CU) are released by Microsoft every couple months. A CU contains fixes for issues in SQL Server, and it allows Microsoft to distribute fixes in between releases of Service Packs which come out a lot less frequently. CUs are intended to correct very specific problems. Microsoft recommends that CUs are applied only to systems that are experiencing the specific problems identified in the documentation for the CUs.

1495826 - Cumulative Updates for Microsoft SQL Server

Regards

Siva