Solution : https://service.sap.com/sap/support/notes/683447 (SAP Service marketplace login required)
Summary :
This SAP Note emphasizes the deployment and management of SAP systems utilizing SAP Tools for MS SQL Server, now integrated into the SAP Software Provisioning Manager (SWPM), part of the SL Toolset. It provides detailed guidance on using 'Database Copy Completion' and 'Schema Conversion' for system copies and schema alterations specifically for older SAP releases up to NW 6.40, as well as database upgrades across various SQL Server versions. The Note specifies software prerequisites and step-by-step processes for ensuring successful configurations or upgrades, including significant considerations and preparations for operational stability and data integrity.
Key words :
-> generic installation options -> ms sql server -> database toolsif, -> generic installation options -> ms sql server -> database tools, dbs/mss/server dbs/mss/server=$, usr\sap\sid\sys\profiles, dbs/mss/server=<hostname>, ms sql server database copy, sap note 799058 ms sql server 2008, sap note 1152240 ms sql server 2012, configure database-related parameters, basis support package level
Related Notes :
| 1563579 | Central Release Note for Software Logistics Toolset 1.0 |
| 1368164 | MAIN_NEWBASE/MSSQL_SCHEMA_CNG fails on SQL 2000 |
| 1152240 | Setting Up Microsoft SQL Server 2008 (R2) |
| 806925 | SQL Error 4064: Cannot open user default database |
| 799058 | Setting Up Microsoft SQL Server 2005 |
| 610640 | sp_check_sap_login |
| 551915 | R/3 won't start after database restore or database copy |
| 505906 | SQL Server: Incorrect collation |