查看表时出现Sql错误 [英] Sql error on viewing the table

问题描述

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

解决方案

如果我是您，我会检查系统事件日志;您可能在托管C：分区的硬盘驱动器有问题。

如果在那里报告了错误，您应该从命令行检查此驱动器的运行状况：

 chkdsk c：/ r 

并在它询问您是否要在下次重启时执行此操作时回答是。然后重新启动并等待进程结束（如果此分区很大并且你有很多文件可能需要很长时间）。



如果分区没有错误，那么我会尝试备份数据库，删除它，然后从备份中恢复它。



希望这有帮助。

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xd88cd4d4; actual: 0xd88cdcd4). It occurred during a read of page (1:2963) in database ID 5 at offset 0x00000001726000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\MicroFinance.mdf'. 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.

解决方案

If I were you, I would check for system event log ; you may have a problem with the hard drive hosting your C: partition.
If there are errors reported in there, you should check for the health of this drive from a command line:

chkdsk c: /r

and answer yes when it asks you whether you want to do it at next reboot. Then reboot and wait for the end of the process (which may take a long time if this partition is large and you have a lot of files in it).

If there are no errors with the partition, then I would try to backup the database, dropt it, and restore it back from the backup.

Hope this helps.

这篇关于查看表时出现Sql错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！