Z
zf501
Unregistered / Unconfirmed
GUEST, unregistred user!
为什么SQl 7 不能启动,按上start 几秒后又stop了。
以下是Errorlog:
2001-08-28 10:38:08.02 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 5)
2001-08-28 10:38:08.02 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2001-08-28 10:38:08.02 kernel All rights reserved.
2001-08-28 10:38:08.02 kernel Logging SQL Server messages in file 'C:/MSSQL7/log/ERRORLOG'.
2001-08-28 10:38:08.03 kernel initconfig: Number of user connections limited to 32767.
2001-08-28 10:38:08.03 kernel SQL Server is starting at priority class 'normal'(1 CPU detected).
2001-08-28 10:38:08.04 kernel User Mode Scheduler configured for thread processing
2001-08-28 10:38:09.04 server Directory Size: 5385
2001-08-28 10:38:09.05 spid1 Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks
2001-08-28 10:38:09.05 kernel Attempting to initialize Distributed Transaction Coordinator.
2001-08-28 10:38:09.05 spid1 Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
2001-08-28 10:38:09.05 spid1 Starting up database 'master'.
2001-08-28 10:38:09.05 spid1 Opening file C:/MSSQL7/data/master.mdf.
2001-08-28 10:38:09.06 spid1 Opening file C:/MSSQL7/data/mastlog.ldf.
2001-08-28 10:38:09.13 spid1 Loading SQL Server's Unicode collation.
2001-08-28 10:38:09.14 spid1 Loading SQL Server's non-Unicode sort order and character set.
2001-08-28 10:38:09.21 spid1 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 1, PSS = 0x11bca084, EC = 0x11bca234
Stack Dump being sent to C:/MSSQL7/log/SQL00050.dmp
*******************************************************************************
*
* BEGIN STACK DUMP:
* 08/28/01 10:38:09 spid 1
*
*
*******************************************************************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f57a2b Module(ntdll+7a2b) (ZwGetContextThread+b)
0x00778999 Module(sqlservr+378999) (utassert_fail+1a0)
0x005884bd Module(sqlservr+1884bd) (RecoveryMgr::AnalysisPass+9c7)
0x004c10d2 Module(sqlservr+c10d2) (RecoveryMgr::RecoverDb+22c)
0x004be9c4 Module(sqlservr+be9c4) (DBTABLE::Startup+624)
0x004bdfae Module(sqlservr+bdfae) (DBMgr::StartupDB+2c4)
0x004c9f3e Module(sqlservr+c9f3e) (DBMgr::StartMaster+9)
0x004c7562 Module(sqlservr+c7562) (initmaster+346)
0x004c52fa Module(sqlservr+c52fa) (init_routine+ba)
0x41092be1 Module(ums+2be1) (ProcessWorkRequests+ed)
0x4109336a Module(ums+336a) (ThreadStartRoutine+139)
0x7800c0d7 Module(MSVCRT+c0d7) (beginthread+ce)
0x77ed4f05 Module(KERNEL32+4f05) (lstrcmpiW+be)
0x00000000 Module(sqlservr+ffc00000)
2001-08-28 10:38:09.55 kernel SQL Server Assertion: File: <recovery.c>, line=2657
Failed Assertion = 'seenCkptEnd'.
2001-08-28 10:38:09.56 spid1 Location: recovery.c:2657
Expression: seenCkptEnd
SPID: 1
Process ID: 141
2001-08-28 10:38:09.56 spid1 Error: 3624, Severity: 20, State: 1.
2001-08-28 10:38:09.56 spid1 Error: 9003, Severity: 20, State: 1.
2001-08-28 10:38:09.56 spid1 Cannot recover the master database. Exiting.
以下是Errorlog:
2001-08-28 10:38:08.02 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 5)
2001-08-28 10:38:08.02 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2001-08-28 10:38:08.02 kernel All rights reserved.
2001-08-28 10:38:08.02 kernel Logging SQL Server messages in file 'C:/MSSQL7/log/ERRORLOG'.
2001-08-28 10:38:08.03 kernel initconfig: Number of user connections limited to 32767.
2001-08-28 10:38:08.03 kernel SQL Server is starting at priority class 'normal'(1 CPU detected).
2001-08-28 10:38:08.04 kernel User Mode Scheduler configured for thread processing
2001-08-28 10:38:09.04 server Directory Size: 5385
2001-08-28 10:38:09.05 spid1 Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks
2001-08-28 10:38:09.05 kernel Attempting to initialize Distributed Transaction Coordinator.
2001-08-28 10:38:09.05 spid1 Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
2001-08-28 10:38:09.05 spid1 Starting up database 'master'.
2001-08-28 10:38:09.05 spid1 Opening file C:/MSSQL7/data/master.mdf.
2001-08-28 10:38:09.06 spid1 Opening file C:/MSSQL7/data/mastlog.ldf.
2001-08-28 10:38:09.13 spid1 Loading SQL Server's Unicode collation.
2001-08-28 10:38:09.14 spid1 Loading SQL Server's non-Unicode sort order and character set.
2001-08-28 10:38:09.21 spid1 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 1, PSS = 0x11bca084, EC = 0x11bca234
Stack Dump being sent to C:/MSSQL7/log/SQL00050.dmp
*******************************************************************************
*
* BEGIN STACK DUMP:
* 08/28/01 10:38:09 spid 1
*
*
*******************************************************************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f57a2b Module(ntdll+7a2b) (ZwGetContextThread+b)
0x00778999 Module(sqlservr+378999) (utassert_fail+1a0)
0x005884bd Module(sqlservr+1884bd) (RecoveryMgr::AnalysisPass+9c7)
0x004c10d2 Module(sqlservr+c10d2) (RecoveryMgr::RecoverDb+22c)
0x004be9c4 Module(sqlservr+be9c4) (DBTABLE::Startup+624)
0x004bdfae Module(sqlservr+bdfae) (DBMgr::StartupDB+2c4)
0x004c9f3e Module(sqlservr+c9f3e) (DBMgr::StartMaster+9)
0x004c7562 Module(sqlservr+c7562) (initmaster+346)
0x004c52fa Module(sqlservr+c52fa) (init_routine+ba)
0x41092be1 Module(ums+2be1) (ProcessWorkRequests+ed)
0x4109336a Module(ums+336a) (ThreadStartRoutine+139)
0x7800c0d7 Module(MSVCRT+c0d7) (beginthread+ce)
0x77ed4f05 Module(KERNEL32+4f05) (lstrcmpiW+be)
0x00000000 Module(sqlservr+ffc00000)
2001-08-28 10:38:09.55 kernel SQL Server Assertion: File: <recovery.c>, line=2657
Failed Assertion = 'seenCkptEnd'.
2001-08-28 10:38:09.56 spid1 Location: recovery.c:2657
Expression: seenCkptEnd
SPID: 1
Process ID: 141
2001-08-28 10:38:09.56 spid1 Error: 3624, Severity: 20, State: 1.
2001-08-28 10:38:09.56 spid1 Error: 9003, Severity: 20, State: 1.
2001-08-28 10:38:09.56 spid1 Cannot recover the master database. Exiting.