2010-11-27 17:03:14.74 Server      (c) 2005 Microsoft Corporation.
2010-11-27 17:03:14.74 Server      All rights reserved.
2010-11-27 17:03:14.74 Server      Server process ID is 45888.
2010-11-27 17:03:14.74 Server      Authentication mode is MIXED.
2010-11-27 17:03:14.76 Server      Logging SQL Server messages in file 'D:\sql2005\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-11-27 17:03:14.76 Server      This instance of SQL Server last reported using a process ID of 7620 at 2010-11-27 16:58:10 (local) 2010-11-27 8:58:10 (UTC). This is an informational message only; no user action is required.
2010-11-27 17:03:14.76 Server      Registry startup parameters:
2010-11-27 17:03:14.82 Server           -d D:\sql2005\MSSQL.1\MSSQL\DATA\master.mdf
2010-11-27 17:03:14.82 Server           -e D:\sql2005\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-11-27 17:03:14.82 Server           -l D:\sql2005\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-11-27 17:03:15.21 服务器         SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-11-27 17:03:15.21 服务器         Detected 4 CPUs. This is an informational message; no user action is required.
2010-11-27 17:03:20.13 服务器         Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2010-11-27 17:03:24.73 服务器         Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-11-27 17:03:27.13 服务器         Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-11-27 17:03:27.38 服务器         Database mirroring has been enabled on this instance of SQL Server.
2010-11-27 17:03:28.62 spid5s      Starting up database 'master'.
2010-11-27 17:03:29.90 spid5s      5 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2010-11-27 17:03:30.05 spid5s      0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2010-11-27 17:03:30.05 spid5s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2010-11-27 17:03:30.58 spid5s      SQL Trace ID 1 was started by login "sa".
2010-11-27 17:03:30.70 spid5s      Starting up database 'mssqlsystemresource'.
2010-11-27 17:03:30.77 spid5s      The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
2010-11-27 17:03:31.32 spid5s      Server name is 'STAR65225692'. This is an informational message only. No user action is required.
2010-11-27 17:03:31.33 spid9s      Starting up database 'model'.
2010-11-27 17:03:31.65 spid9s      Clearing tempdb database.
2010-11-27 17:03:35.08 服务器         A self-generated certificate was successfully loaded for encryption.
2010-11-27 17:03:35.24 服务器         Server is listening on [ 'any' <ipv4> 1433].
2010-11-27 17:03:35.58 服务器         Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2010-11-27 17:03:35.58 服务器         Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2010-11-27 17:03:35.66 服务器         Server is listening on [ 127.0.0.1 <ipv4> 1434].
2010-11-27 17:03:35.66 服务器         Dedicated admin connection support was established for listening locally on port 1434.
2010-11-27 17:03:36.29 服务器         The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2010-11-27 17:03:36.29 服务器         SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-11-27 17:03:38.74 spid12s     Starting up database 'msdb'.
2010-11-27 17:03:38.82 spid15s     Starting up database 'JShop'.
2010-11-27 17:03:38.82 spid16s     Starting up database 'RRGame_Game'.
2010-11-27 17:03:38.90 spid13s     Starting up database 'RRGame'.
2010-11-27 17:03:38.90 spid14s     Starting up database 'ItStrikeAsk'.
2010-11-27 17:03:38.92 spid17s     Starting up database 'ItStrikeAskEn'.
2010-11-27 17:03:41.18 spid17s     1 transactions rolled forward in database 'ItStrikeAskEn' (12). This is an informational message only. No user action is required.
2010-11-27 17:03:41.25 spid16s     1 transactions rolled forward in database 'RRGame_Game' (11). This is an informational message only. No user action is required.
2010-11-27 17:03:41.28 spid5s      0 transactions rolled back in database 'ItStrikeAskEn' (12). This is an informational message only. No user action is required.
2010-11-27 17:03:41.28 spid5s      Recovery is writing a checkpoint in database 'ItStrikeAskEn' (12). This is an informational message only. No user action is required.
2010-11-27 17:03:41.36 spid15s     1 transactions rolled forward in database 'JShop' (10). This is an informational message only. No user action is required.
2010-11-27 17:03:41.48 spid5s      0 transactions rolled back in database 'RRGame_Game' (11). This is an informational message only. No user action is required.
2010-11-27 17:03:41.48 spid5s      Recovery is writing a checkpoint in database 'RRGame_Game' (11). This is an informational message only. No user action is required.
2010-11-27 17:03:42.42 spid5s      0 transactions rolled back in database 'JShop' (10). This is an informational message only. No user action is required.
2010-11-27 17:03:42.44 spid5s      Recovery is writing a checkpoint in database 'JShop' (10). This is an informational message only. No user action is required.
2010-11-27 17:03:42.45 spid12s     2 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2010-11-27 17:03:42.45 spid9s      Starting up database 'tempdb'.
2010-11-27 17:03:43.72 spid5s      0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2010-11-27 17:03:43.72 spid5s      Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2010-11-27 17:03:45.08 spid13s     2643 transactions rolled forward in database 'RRGame' (6). This is an informational message only. No user action is required.
2010-11-27 17:03:45.30 spid15s     The Service Broker protocol transport is disabled or not configured.
2010-11-27 17:03:45.30 spid15s     The Database Mirroring protocol transport is disabled or not configured.
2010-11-27 17:03:45.50 spid5s      0 transactions rolled back in database 'RRGame' (6). This is an informational message only. No user action is required.
2010-11-27 17:03:45.50 spid5s      Recovery is writing a checkpoint in database 'RRGame' (6). This is an informational message only. No user action is required.
2010-11-27 17:03:46.27 spid15s     Service Broker manager has started.
2010-11-27 17:03:57.68 spid14s     5843 transactions rolled forward in database 'ItStrikeAsk' (9). This is an informational message only. No user action is required.
2010-11-27 17:03:58.55 spid5s      0 transactions rolled back in database 'ItStrikeAsk' (9). This is an informational message only. No user action is required.
2010-11-27 17:03:58.55 spid5s      Recovery is writing a checkpoint in database 'ItStrikeAsk' (9). This is an informational message only. No user action is required.
2010-11-27 17:03:58.92 spid5s      Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2010-11-27 17:03:58.95 spid5s      Recovery is complete. This is an informational message only. No user action is required.
2010-11-27 17:07:31.00 spid74      Using 'xplog70.dll' version '2005.90.4035' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2010-11-27 17:07:31.44 spid74      Using 'xpstar90.dll' version '2005.90.4035' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.