MS SQL Upgrade from 2008 R2 to 2012 in SAP server.
Based on recent MS SQL upgrade project , today I am hereby tracking out all the required steps to upgarde MS SQL database of SAP server from 2008 R2 to 2012.
1. SAP server : SAP BI with Netweaver 7.3 EHP1.
2. MS SQL : 2008 R2 (Version: 10.50.1702.00)
3. OS: Windows 2008 R2
Please check the pre-requisite of SAP-ABAP, SAP-BASIS, SAP-BW, kernel details as per note 0001676665 and 0001651862 . Based on NW 7.3 EHP1 SP6, I have kept dependent components in following stage:-
kernel : 720 UC – 402 (Extended)
SAP_ABA : Rel (731), Level (0006) [Minimum requirement is level 0003]
SAP_BASIS : Rel (731), Level (0006) [Minimum requirement is level 0003]
One more pre-requisite is there that MS SQL 2008 R2 should be upgraded to SP1 or to later version. You can download the support pack from http://www.microsoft.com/en-us/download/details.aspx?id=30437 based on your requirement like X64, IA64, X86 . After downloading the .exe file execute the file (Run as Administrator) . Please note that during upgrading database, stop all the SAP instance and MMC.
After completion of fulfilling all the pre-requisites, follow the below steps to upgrade database to MS SQL 2012 :-
1. Download the MS SQL 2012 database dump from SMP (https://service.sap.com/swdc -> Database and Database Patches -> MS SQL Server -> Database -> then select the version and download with you S – ID)
2. Stop all the SAP instances.
3. Run setup.exe (Application) available under ‘MS_SQL_2012R2\51046000\x86-x64\EnterpriseEdition’.
4. Select ‘Installation’ under SQL server installation Center and then click on ‘Upgrade from MS SQL 2005 or from MS SQL 2008’.
5. Then press NEXT till you end the upgrade. [During this operation, it will check whether required space is available or not in installation drive, so if it shows warning , then increase the size as per new requirement]
6. Once upgrade gets completed , run SWPM .
NB: You can download SWPM from https://service.sap.com/swdc ->Support Packages and Patches -> S -> ” SL TOOLSET” SL TOOLSET 1.0″ -> Entry by Component -> ” Software Provisioning Manager ” -> SOFTWARE PROVISIONING MGR 1.0 -> Windows server X 64 64 bit (as per my req.) -> Then download ‘Software Provisioning Manager1.0 SP2 for NW higher than 7.0x ‘ .
7. Select ‘Generic Installation Options’ -> ‘MS SQL Server’ -> ‘Database Tools’ -> ‘Database Upgrade Completion’ and execute.
8. Give profile location and password of SIDADM and click NEXT.
9. In case you get ‘database Connection issue’, please maintain following environmental variable in SAP server :-
dbs/mss/server= <local host name>
10. In case any issue appears , you can view the logs under “<Drive>:\Program Files\sapinst_instdir\GENERIC\MSS\DBTOOLS\MSS\YUP\. “.
11. After successful completion of upgrade and synchronization, start SAP instance from MMC and check the version of MS SQL in both SQL studio and SAP front-end (System details).
I hope these steps would surely help most of SCNians.