Component : Microsoft SQL Server -

Solution : https://service.sap.com/sap/support/notes/555223 (SAP Service marketplace login required)

Summary :
This SAP Note addresses multiple issues and features concerning Microsoft SQL Server usage within an SAP context. Key points include explanations about the SQL Server transaction log's indispensability and management, integrating SAP systems with non-SAP SQL databases via ABAP and multi-connect, SQL login configurations for SAPService and adm users, and adjustments of physical database layouts. It discusses performing a homogeneous system copy, handling full transaction logs, updating password protocols for security reasons, and troubleshooting connection errors with external SAP tools. Further support includes details on supported SQL Server releases, maintenance of SAP Database Monitor, optimal configurations for performance, and data management guidelines following significant deletions from databases.

Key words :
terms 9002 sa password dbsl libdbsl dbmssslib dbcontransaction log sql server configuration user multi-connect multiconnect multiconnect layout faq homogeneous system copy tp saplicenser3trans service pack st04 db02 db12 db13 monitor faq bw performance solution q1, rid=/library/uuid/4ab89e84-0d01-0010-cda2-82ddc3548c65document title, called multi-connect, homogeneous system copy, note 1241751 - sql server minimal logging extensions, sap service marketplace www, sap bw performance, setting special database recovery models, sql server automatically reclaims extents, symptom q1

Related Notes :

1294762	SCHEMA4SAP.VBS
1241751	SQL Server minimal logging extensions
551915	R/3 won't start after database restore or database copy
421644	SQL error 9002: The transaction log is full
307911	Transaction Log Filling Up in SQL Server 7.0
178949	MSSQL: Database MultiConnect with EXEC SQL
166861	Analysis of DB13 problems
151603	Copying an SQL Server database
139945	SAP Database Monitor for MS SQL Server
128126	Database connect for external tools
62988	Service Packs for Microsoft SQL Server
28893	Changing passwords for SQL Server