Viewing the Error Log with the
SAP System 
Use
The error log is a central file in which all the important actions and error messages concerning the database are recorded. The database administrator should examine the log every day.
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 the button to the left of the entry and then click in the scroll bar.
A new error log is created each time SQL Server is started. 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 6 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 is started, the archived oldest log files are overwritten and are lost, unless you save them first. If you have a serious problem, you should immediately save these files otherwise they will be lost.
By using the SEARCH button, a keyword like BACKUP can be entered and all the SQL Server ERRORLOGS will be searched for the word BACKUP. The search looks for an exact match on the input phrase.
See also: