Search This Blog

Friday, July 24, 2009

How to apply MSSQL Patch/SP for DB in SAP System

SAP System
DB - MSSQL
OS - Windows Server


Straight and Simple:

  1. Download the patch from SAP Service MarketPlace
  2. Stop SAP using MMC
  3. Stop DB using MS Visual Studio
  4. Stop all SAP Services from service.msc
  5. Stop all SQL Services from service.msc
  6. Close MMC console
  7. Close MS Visual Studio console
  8. Drill down the installer for your OS/HW from the downloaded media, i.e. x64, x86, etc.
  9. Double Click the installer
  10. Let the installer check if any conflicting services are running or not
  11. Complete the installation
  12. Check DB/Bring DB online
  13. Check SQL services/Start SQL services from service.msc
  14. Start SAP services from service.msc
  15. Start SAP using MMC
SQL Patching is done!

Check and confirm SQL patch number from MS Visual Studio.

Good luck!

Shival

No comments:

Post a Comment