sql server 2000 torn_page_detection error (error 823)
来源:互联网 发布:python spark z 编辑:程序博客网 时间:2024/05/29 08:50
2010-08-05 09:21:51.31 spid11 错误: 823,严重度: 24,状态: 2
2010-08-05 09:21:51.31 spid11 I/O error (torn page) detected during read at offset 0x0000116496a000 in file 'd:/Microsoft SQL Server/MSSQL/data/xxxxxxx_Data.MDF'.
======================================================
Description&Solution:
Torn_page_detection:
This recovery option allows SQL Server to detect incomplete I/O operations caused by power failures or other system outages.
When set to ON, this option causes a bit to be reversed for each 512-byte sector in an 8-kilobyte (KB) database page when the page is written to disk. If a bit is in the wrong state when the page is later read by SQL Server, the page was written incorrectly; a torn page is detected. Torn pages are usually detected during recovery because any page that was written incorrectly is likely to be read by recovery.
Although SQL Server database pages are 8 KB, disks perform I/O operations using a 512-byte sector. Therefore, 16 sectors are written per database page. A torn page can occur if the system fails (for example, due to power failure) between the time the operating system writes the first 512-byte sector to disk and the completion of the 8-KB I/O operation. If the first sector of a database page is successfully written before the failure, the database page on disk will appear as updated, although it may not have succeeded.
Note Using battery-backed disk caches can ensure that data is successfully written to disk or not written at all.
If a torn page is detected, an I/O error is raised and the connection is killed. If the torn page is detected during recovery, the database is also marked suspect. The database backup should be restored, and any transaction log backups applied, because it is physically inconsistent.
By default, TORN_PAGE_DETECTION is ON.
- sql server 2000 torn_page_detection error (error 823)
- Sql Server 2000 install error
- SQL Server error 5120
- SQL Server @@ERROR 用法
- SQL Server @@ERROR 用法
- SQL Server Error:233 and Error 18452
- SQL Server 2005 error handling
- 安装SQL Server 2005 error
- SQL Server Error Log 管理
- Microsoft SQL Server Error 5030
- 查看SQL Server error log
- SQL Server @@ROWCOUNT 、@@ERROR用法
- SQL Server 连接error: 40
- [sql] sql server初次链接error
- SQL Server 2000 "Error establishing socket" 错误的解决办法
- [Microsoft][SQL Server 2000 Driver for JDBC]Error establishing socket.
- SQL Server 2000 安装失败 ERROR 193 1060
- provider: SQL Network Interfaces , error: 26 - Error Locating Server / Instance
- GTK +
- 读取配置文件的方法getcfg()
- #pragma once 与 #if !defined 分开了
- 【飞秋】使用C++语言创建Silverlight中的VisualState
- 各种咖啡的说明
- sql server 2000 torn_page_detection error (error 823)
- 一些有用的类库转载
- 【飞秋】位运算与组合搜索(二)
- pku3372(找规律,公式,推理)
- Gridview用法:根据某列的值改变gridview其他列的属性
- javascript 抛出自定义错误
- ETC——001
- 【飞秋】做需求分析一点心得
- Junit: How to skip a test case in Junit ?