来自Eventviewer的SQL Server错误消息 [英] Error message from Eventviewer for 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
推荐答案
SQLEXPRESS
显示名称： - SQL Server（SQLEXPRESS）
以下是我从Eventviewer中为SQL Server提取的错误消息
---- -------------------------------------------------- -
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，因为服务已关闭
请在这里帮助我
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
Google问题 [ ^ ]？
前两个看起来非常有用......
Google the problem[^] ?
The first two look extremely useful ...
这篇关于来自Eventviewer的SQL Server错误消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
