Administration of SAP system with SQL server

[Former Member]

Hi!

I have the following questions regarding SAP on SQL Server.

1) Reduce of size of redo log file.

We have created a 24 GB Log file. How can we reduce this file?

2) Monitoring of SAP system with SQL Server on SAP Solution Manager (RZ20)

How can SAP system with SQL Server be monitored on SAP Solution Manager from RZ20?

3) Are there other useful information regarding SAP basis administration of SAP with SQL server?

Any helpful information will be very appreciated

regards

[Former Member]

Hi,

Here is the required information.

1) Reduce of size of redo log file.

We have created a 24 GB Log file. How can we reduce this file?

First of all, It is called as Transaction Log file in SQL and not the redo log file.

To reduce the size of the Transaction Log file, you first have to take the transaction log backup. Once the transactional data is backed up, you can shrink the file through SQL management studio.

For that go to SQL management studio. Right click on the database --> Tasks --> Shrink --> Files. Select the file type as log and select the relevant file name. Keep the shrink action as Release unused space and click Ok. Unused space will be released and the file will reduce.

2) Monitoring of SAP system with SQL Server on SAP Solution Manager (RZ20)

How can SAP system with SQL Server be monitored on SAP Solution Manager from RZ20?

What type of monitoring do you exactly require from SAP Solution Manager? Is it the general availability of the SAP system and the database? For that you need to register the CCMS agents (SAPCCM4X for SAP and SAPCCMR for DB). An SAP system can be monitored through the SAP Solution Manager independent of the database.

3) Are there other useful information regarding SAP basis administration of SAP with SQL server?

Here are some of the useful links for SQL server administration

http://help.sap.com/saphelp_nw04/helpdata/en/3d/11ffa78c672844a242ed4a85a4da31/frameset.htm

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f02fcf34-9116-2a10-1183-f2a8c794d16f

http://help.sap.com/saphelp_nw04/helpdata/en/d8/07b839f6a7a307e10000000a11402f/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/f2/31ad8f810c11d288ec0000e8200722/content.htm

Thanks,

Varun

[Former Member]

Hi,

1. Check Note 363018 - File management for SQL Server

2. Check http://service.sap.com/monitoring. Please be a bit more specific - I dont really get your point.

3. Check Note 1027512 - MSSQL: DBA cockpit for basis release 7.00 and later. Same issue - please be a bit more specific (e.g. what version of SQL Server/SAP).

Sites to have a look at:

- http://blogs.msdn.com/saponsqlserver/

- read thru this forum, a lot of issues have been discussed here

Sven