SAP on Sql server

SAP on Sql  server

SAP Database  <SID>

Files

File System <drive>:\<SID>DATA1\<SID>DATA1.mdf

<drive>:\<SID>DATA2\<SID>DATA2.ndf

<drive>:\<SID>DATAn\<SID>DATAn.ndf

<drive>:\<SID>LOG1\<SID>LOG1.ldf

<drive>:\<SID>LOGm\<SID>LOGm.ldf

Filegroup PRIMARY

...

<drive>:\<SID>DATA3\<SID>DATA3.ndf

...

<SID>DATA1

<SID>DATA2

<SID>DATA3

<SID>DATAn

<SID>LOG1

<SID>LOGm

...

SAP Database Files

Each database has two logical parts: data (data files) and transaction log (log files). When SQL

Server and the SAP System are installed, the data files of the <SID> database are created in the

directories <drive>:\<SID>DATA1\<SID>DATA1.mdf and

<drive>:\<SID>DATAn\<SID>DATAn.ndf, where n is the number of the file. The data files may

reside on different physical drives. SAP recommends storing the data files using RAID5. The

standard installation creates 3 data files. This makes it easier to expand the database. 

 The transaction log file is created in the directories <drive>:\<SID>LOG1\<SID>LOG1.ldf and

<drive>:\<SID>LOGm\<SID>LOGm.ldf, where m is the number of the file. The log files must be

mirrored. Hardware mirroring using RAID1 is strongly recommended. The standard installation

creates one log file.

After a standard installation, all SAP data files reside in the special filegroup PRIMARY.

 Stored procedure sp_helpfile returns the physical names and attributes of files associated with the

current database. Use this stored procedure to determine the names of files attached to one database.