Viewing the Error Log with the SAP System 

Use

The error log is a central file(s) in which all the important actions and error messages concerning the database are recorded. The database administrator should examine the log every day.

The same screen can also be reached using transaction code DBACOCKPIT, opening the Diagnostics folder, and selecting SQL Error Logs.

Procedure

...

...

       1.      To view the error log, choose CCMS ® Control/Monitoring ® Performance Menu ® Database ® Activity. Alternatively enter the transaction code ST04.

       2.      Choose Detail Analysis Menu.

       3.      Choose Error Logs.

All the available error logs are listed.

       4.      To display the contents of a particular log, click on it to list its contents below.

A new error log is created each time SQL Server starts. SQL Server retains backups of the previous six error logs. If the log file name is E:\ Program Files\Microsoft SQL Server\LOG\ERRORLOG, the last six log files are archived under the following names:

E:\ Program Files\Microsoft SQL Server\LOG\ERRORLOG.1

E:\ Program Files\Microsoft SQL Server\\LOG\ERRORLOG.2 …

E:\ Program Files\Microsoft SQL Server\\LOG\ERRORLOG.6

Each time the SQL Server starts, the archived oldest log files are overwritten and lost, unless you save them first. If you have a serious problem, you should immediately save these files otherwise they are lost.

Pay special attention to the columns >17 and >20. If a Y appears in these columns, it means a noteworthy severity level error message has occurred, and the cause should be investigated.