本文介绍了来自Eventviewer的SQL Server错误消息的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

最近我使用的SQL Server 2008运行良好。但突然出现错误,即使我手动启动,我的服务也会自动停止。



服务名称: - MSSQL $ SQLEXPRESS

显示名称: - SQL Server(SQLEXPRESS)



以下是我从Eventviewer for SQL中提取的错误消息服务器

----------------------------------------- --------------



SQL Server检测到基于逻辑一致性的I / O错误:校验和不正确(预期:0x0002c6dc;实际:0x6450282c)。它发生在数据库ID 3中的页面(2:0)读取文件C:\Program Files \ Microsoft SQL Server \ MSSQL10.SQLEXPRESS \ MSSQL \DATA\modellog.ldf中的偏移0000000000000000处。 SQL Server错误日志或系统事件日志中的其他消息可能提供更多详细信息。这是严重错误情况,威胁数据库完整性,必须立即纠正。完成完整的数据库一致性检查(DBCC CHECKDB)。这个错误可能是由许多因素造成的;有关详细信息,请参阅SQL Server联机丛书。





解决方案

1)我认为操作系统可能有一些问题,所以我编写了PC并再次安装SQL仍然没有问题。



2)看到一个解决方案互联网它说在SQL中运行 DBCC 命令,但问题是我无法登录SQL,因为服务已关闭





请在这里帮助我

Recently i was using SQL Server 2008 which worked fine. But suddenly an error has appeared and my service gets automatically stopped even after i start it manually.

Service Name :- MSSQL$SQLEXPRESS
Display Name :- SQL Server (SQLEXPRESS)

Below is the error message i extracted from Eventviewer for SQL Server
-------------------------------------------------------

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x0002c6dc; actual: 0x6450282c). It occurred during a read of page (2 : 0) in database ID 3 at offset 0000000000000000 in file "C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\modellog.ldf". Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.


Solutions Tried
1) I thought the OS might have some problem so i formated the PC and installed the SQL again still the problem was not gone.

2) Saw a solution on internet it says run DBCC command in SQL but the problem is i cannot log in SQL as the service is close


Please help me here

推荐答案



这篇关于来自Eventviewer的SQL Server错误消息的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-18 22:23