Solution : https://service.sap.com/sap/support/notes/151603 (SAP Service marketplace login required)
Summary :
This SAP Note outlines the process for copying an SQL Server database within a homogeneous system copy, applicable to SAP systems utilizing SAP databases such from modules like BW and CRM. It details system copy procedures using SQL Server stored procedures sp_detach_db, sp_attach_db, or the 'CREATE DATABASE FOR ATTACH' command. A structured process from preparation, file structure analysis, creating directory structures, detaching, and reattaching databases ensures integrity and minimal disruption. The instructions require adherence to version compatibilities and prerequisite configurations for the SQL Server and SAP system. For database upgrades across different SQL Server versions, corresponding precautions and steps are specified to manage database file versions and ensure system functionality post-migration.
Key words :
<sapsid>gosetuser '<sid>'gotruncate table sdbaptruncate table sdbarnon-schema system, truncate table sap_perfsampletruncate table sap_perfinfotruncate table sap_perfvali, <sapsid>truncate table sdbaptruncate table sdbarthen create, <sapsid>gosetuser '<sid>'goexec sap_droprocnon-schema system, <sapsid>gosetuser '<sid>'gotruncate table sap_perfhist, <sapsid>goexec sap_droprocthese commands delete, permanent stored procedurescall transaction se38, <sapsid>truncate table sap_perfhist, delivered sap installation master dvd, alter database tempdb modify file
Related Notes :
| 1471910 | SQL Server Partitioning in System Copies and DB Migrations |
| 1458291 | SolMan 7.1 Database Warehouse & Alerting for MSSQL |
| 1388700 | SQL Server Remote Database Monitor in Solution Manager 400 |
| 960769 | Windows: Migration from 32-bit to 64-bit (x86_64) |
| 666805 | MS SQL Server: Migrating from 32-bit to 64-bit |
| 600027 | Installing the Corrected MS SQL Server Collation |
| 555223 | FAQ: Microsoft SQL Server |
| 551915 | R/3 won't start after database restore or database copy |
| 363018 | File management for SQL Server |
| 339912 | R3COPY on NT-MS SQL Server |
| 193816 | Restore with SQL Server |
| 172547 | Platform changes between Intel and Alpha with SQL Server 7.0 |