Please check the related suggestions for detailed records of SQL SERVER operation logs.

From Introduction to Practice of SQL Server 2005 (12-hour high-definition interactive video teaching) The third chapter tells how to use the management tools provided by SQL Server 2005 to configure and manage the database server and build an available, stable and high-performance database service environment. This section describes how to view SQL Server logs.

3.5 Check the operation of the server through the log.

SQL Server 2005 database provides a powerful logging tool to record the operation of the database system. This tool helps users to manage the server, especially in the case of errors. Using the log viewing function can narrow the scope of causes and help to find and solve problems in time. The SQL Server database records some system events and user-defined events in the SQL Server error log and Windows application log.

3.5. 1 View SQL Server log

SQL Server logs record the complete status information of SQL Server database operations, and record system-level and application-level operations in the form of messages. Users can use the SQL Server Management Studio management tool to view SQL Server logs. The specific operation steps are as follows.

(1) Choose Start | Programs | Microsoft SQL Server 2005 | SQL Server Management Studio to start the SQL Server Management Studio management tool.

(2) In the Object Explorer component window, expand the Servers | Management |“SQL Server Logs node in turn.

(3) Double-click the log record to open the log file viewer dialog box, which will list the SQL Server logs.