急!!!SQL Server服务器一启动就自动停止,希望大家帮忙。
日志如下:
2003-08-23 11:51:07.49 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows 4.10 (Build 2222: A )
2003-08-23 11:51:07.52 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2003-08-23 11:51:07.52 kernel All rights reserved.
2003-08-23 11:51:07.53 kernel Logging SQL Server messages in file 'C:\MSSQL7\log\ERRORLOG'.
2003-08-23 11:51:07.66 kernel initconfig: Number of user connections limited to 32767.
2003-08-23 11:51:07.66 kernel SQL Server is starting at priority class 'normal'(1 CPU detected).
2003-08-23 11:51:07.82 kernel User Mode Scheduler configured for thread processing
2003-08-23 11:51:09.08 server Directory Size: 2559
2003-08-23 11:51:09.17 spid1 Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
2003-08-23 11:51:09.24 spid1 failed to get sqlservr image range
2003-08-23 11:51:09.31 spid1 Starting up database 'master'.
2003-08-23 11:51:09.32 spid1 Opening file C:\MSSQL7\data\master.mdf.
2003-08-23 11:51:09.44 spid1 Opening file C:\MSSQL7\data\mastlog.ldf.
2003-08-23 11:51:09.55 spid1 Loading SQL Server's Unicode collation.
2003-08-23 11:51:09.64 spid1 Loading SQL Server's non-Unicode sort order and character set.
2003-08-23 11:51:10.02 spid1 Starting up database 'model'.
2003-08-23 11:51:10.02 spid1 Opening file C:\MSSQL7\DATA\model.mdf.
2003-08-23 11:51:10.08 spid1 Opening file c:\mssql7\data\modellog.ldf.
2003-08-23 11:51:10.18 spid1 Clearing tempdb database.
2003-08-23 11:51:10.36 spid1 Creating file C:\MSSQL7\DATA\TEMPDB.MDF.
2003-08-23 11:51:10.67 spid1 Closing file C:\MSSQL7\DATA\TEMPDB.MDF.
2003-08-23 11:51:10.98 spid1 Creating file C:\MSSQL7\DATA\TEMPLOG.LDF.
2003-08-23 11:51:11.00 spid1 Closing file C:\MSSQL7\DATA\TEMPLOG.LDF.
2003-08-23 11:51:11.25 spid1 Opening file C:\MSSQL7\DATA\TEMPDB.MDF.
2003-08-23 11:51:11.25 spid1 Opening file C:\MSSQL7\DATA\TEMPLOG.LDF.
2003-08-23 11:51:11.37 spid1 Closing file C:\MSSQL7\DATA\TEMPDB.MDF.
2003-08-23 11:51:11.63 spid1 Closing file C:\MSSQL7\DATA\TEMPLOG.LDF.
2003-08-23 11:51:11.73 spid1 Starting up database 'tempdb'.
2003-08-23 11:51:12.44 spid1 Opening file C:\MSSQL7\DATA\TEMPDB.MDF.
2003-08-23 11:51:12.44 spid1 Opening file C:\MSSQL7\DATA\TEMPLOG.LDF.
2003-08-23 11:51:12.44 spid1 Bypassing recovery for database 'tempdb' because it is marked SUSPECT.
2003-08-23 11:51:12.58 spid1 Database 'tempdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
2003-08-23 11:51:12.68 spid1 WARNING: problem activating all tempdb files.
2003-08-23 11:51:12.69 spid1 Trying just primary files.
2003-08-23 11:51:12.69 spid1 Database 'tempdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
2003-08-23 11:51:12.69 spid1 Database 'tempdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
==========
也就是“tempdb”打不开。