谁帮我看看sql server的错误日志是什么意思

[Former Member]

SAP Business One 7.10.32

文件名：ERRORLOG.1

-

---

2010-04-15 08:51:53.29 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)

May 3 2005 23:18:38

Copyright (c) 1988-2003 Microsoft Corporation

Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2010-04-15 08:51:53.42 server Copyright (C) 1988-2002 Microsoft Corporation.

2010-04-15 08:51:53.42 server All rights reserved.

2010-04-15 08:51:53.42 server Server Process ID is 1344.

2010-04-15 08:51:53.42 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

2010-04-15 08:51:53.49 server SQL Server is starting at priority class 'normal'(2 CPUs detected).

2010-04-15 08:51:54.23 server SQL Server configured for thread mode processing.

2010-04-15 08:51:54.26 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.

2010-04-15 08:51:55.09 server Attempting to initialize Distributed Transaction Coordinator.

2010-04-15 08:51:55.98 server Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b

2010-04-15 08:51:56.10 spid3 Starting up database 'master'.

2010-04-15 08:52:02.48 spid3 Server name is '1600SC'.

2010-04-15 08:52:02.48 spid5 Starting up database 'msdb'.

2010-04-15 08:52:02.48 server Using 'SSNETLIB.DLL' version '8.0.2039'.

2010-04-15 08:52:02.48 spid6 Starting up database 'model'.

2010-04-15 08:52:02.53 spid8 Starting up database 'pubs'.

2010-04-15 08:52:02.53 spid10 Starting up database 'Northwind'.

2010-04-15 08:52:02.53 spid11 Starting up database 'Sbo-Common'.

2010-04-15 08:52:02.53 spid12 Starting up database 'jili'.

2010-04-15 08:52:02.81 spid13 Starting up database 'baoli'.

2010-04-15 08:52:02.81 server SQL server listening on 192.168.0.100: 1433.

2010-04-15 08:52:03.01 server SQL server listening on 127.0.0.1: 1433.

2010-04-15 08:52:03.93 spid6 Clearing tempdb database.

2010-04-15 08:52:04.98 server SQL server listening on TCP, Shared Memory, Named Pipes.

2010-04-15 08:52:04.98 server SQL Server is ready for client connections

2010-04-15 08:52:09.40 spid6 Starting up database 'tempdb'.

2010-04-15 08:52:33.76 spid3 Recovery complete.

2010-04-15 08:52:33.76 spid3 SQL global counter collection task is created.

2010-04-15 08:52:34.54 spid52 Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'.

2010-04-15 16:17:24.00 spid66 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'sp_MSgetversion'.

2010-04-15 16:20:49.84 backup Database backed up: Database: jili, creation date(time): 2010/01/08(09:02:30), pages dumped: 533236, first LSN: 4509:20314:1, last LSN: 4509:20687:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\sbo backup\jili-2010-04-15'}).

2010-04-16 16:16:46.95 backup Database backed up: Database: jili, creation date(time): 2010/01/08(09:02:30), pages dumped: 533724, first LSN: 4510:25073:1, last LSN: 4510:25104:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\sbo backup\jili-2010-04-16'}).

2010-04-19 16:14:48.63 backup Database backed up: Database: jili, creation date(time): 2010/01/08(09:02:30), pages dumped: 534373, first LSN: 4512:15535:1, last LSN: 4512:15567:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\sbo backup\jili-2010-04-19'}).

2010-04-21 16:24:48.98 backup Database backed up: Database: jili, creation date(time): 2010/01/08(09:02:30), pages dumped: 535221, first LSN: 4514:11511:1, last LSN: 4514:13251:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\sbo backup\jili-2010-04-21'}).

2010-04-23 16:18:59.81 backup Database backed up: Database: jili, creation date(time): 2010/01/08(09:02:30), pages dumped: 536173, first LSN: 4516:24176:1, last LSN: 4516:24333:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\sbo backup\jili-2010-04-23'}).

2010-04-26 16:14:25.67 backup Database backed up: Database: jili, creation date(time): 2010/01/08(09:02:30), pages dumped: 536925, first LSN: 4518:4665:1, last LSN: 4518:4698:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\sbo backup\jili-2010-04-26'}).

2010-04-27 16:14:05.19 backup Database backed up: Database: jili, creation date(time): 2010/01/08(09:02:30), pages dumped: 537197, first LSN: 4518:32642:1, last LSN: 4518:32668:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\sbo backup\jili-2010-04-27'}).

2010-04-28 16:21:14.85 backup Database backed up: Database: jili, creation date(time): 2010/01/08(09:02:30), pages dumped: 537509, first LSN: 4519:32338:1, last LSN: 4519:32364:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\sbo backup\jili-2010-04-28'}).

2010-04-29 15:35:11.85 server SQL Server terminating because of system shutdown.

Edited by: shjili on May 12, 2010 10:13 AM

[Former Member]

I have checked the log. Nothing unusual. It just showed SQL Server terminating because of system shutdown on 4/29.

What are you trying to find?

Thanks,

Gordon