急！！！SQL Server服务器一启动就自动停止，希望大家帮忙。

[slwqw2]

日志如下：

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”打不开。

[slwqw2]

其它老大还有什么高见？

[dreamreality]

你可以去试一试重建master
rebuildm这条命令不知能否解决你的问题

[viiqii]

你先去备份一份你需要的数据吧，
然后重新装一遍，

[pengdali]

拷贝你的data目录下的数据库文件如：
c:\program files\microsoft sql server\mssql\data\

修复安装sqlserver


附加还原原来的数据库
EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'

[llsyhy]

你应该打补丁了sql server 补丁

[slwqw2]

交代清楚一点：

1、使用Win98操作系统。
2、使用本地数据库。

[slwqw2]

你应该打补丁了sql server 补丁

====================

前几天还正常，好像杀过毒之后就不可以了，这和补丁有什么关系？

[hjb111]

可能tempdb文件已经损坏，tempdb是系统数据库，不能被损坏，否则系统就会不正常，重新装一遍吧！

[slwqw2]

可能tempdb文件已经损坏，tempdb是系统数据库，不能被损坏，否则系统就会不正常，重新装一遍吧！

=============

现在麻烦地是，我这里没有盘，没有办法重装，顺便问一下：重装之后，原来的那些数据表是否还存在？

[zarge]

干脆把tempdb.mdf和tempdb.ldf删除掉试试

[wanghan226]

核对正确的系统时间，如果还不行那么可能是数据库的系统文件有错，重新安装，如果还不行那么可能是你的SQLserver版本问题，请到Microsoft网站下载相应的数据库最新补丁。