SQL2k Table 發生 I/O Error 時處理方式

SQL Server 2000 Table 發生 I/O Error 時處理方式


※  狀態

開啟Table 時，Scoll 資料時跳出下列訊息視窗.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Server Enterprise Manager

[Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (torn page) detected during read at offset 0x000000012f4000 in file 'E:\Upload\SMARTIT.MDF'.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[ 確定 ]   [ 說明 ]

※    解決方式

sp_dboption Smartit372,single, true

dbcc checktable ("software",repair_allow_data_loss)

dbcc dbreindex ("software")

sp_dboption SmartIT372, single , false

Posted in: 知識分享, SQLServer