View SQL server logs

Chapter 4 SQL Server 2005 Server Management from SQL Server 3rd to practice (12-hour high definition and interactive video teaching, this chapter describes how to use the management tools provided by SQL Server 2005 to configure and manage database servers and build a stable and high-performance database service environment. This section describes how to view SQL server logs.

AD:

3.5 view server running status through Logs

SQL Server 2005 database provides a powerful logging tool to record the running status of the database system. This tool helps you manage servers, especially when an error occurs. You can use the log view function to narrow down the cause and help you identify and solve the problem in a timely manner. The SQL Server database records some system events and user-defined events to SQL Server error logs and Windows applications.ProgramLogs.

3.5.1 view SQL server logs

The SQL server log records the complete SQL Server database running status information, and records system-level and application-level operations in the form of messages. You can use SQL Server Management studio to view SQL server logs. The procedure is as follows.

(1) Select the "Start" | "program" | "Microsoft SQL Server 2005" | "SQL Server Management Studio" command to start the SQL Server Management studio management tool.

(2) Expand the "server" | "management" | "SQL server log" node in the "Object Resource Manager" component window.

(3) double-click a log record to open the "Log File Viewer" dialog box, as shown in Figure 3-26.

(4) Click "filter" to filter and filter SQL server logs. You can select "text contained in a message", "Start Date", and "result date.