Danh hiệu: Kê Vương
Gia nhập: 23-01-2011(UTC) Bài viết: 2,113  Đến từ: HCM Thanks: 4 times
Được cảm ơn: 300 lần trong 220 bài viết
|
Trích dẫn:After migrating the SQL Server 2005 SP2 32-bit database to SP3 64-bit environment some queries started to complain about the following error in the SQL Server Error Logs.
Message:
SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x0; actual signature: 0x5be5d620). It occurred during a read of page (1:718204) in database ID 7 at offset 0x0000015eaf8000 in file 'E:\MSSQL\DATA\SMPPGatewayBEP.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. Mã:alter database TKOffice_UNILog_HaiQuan_UNILogistics SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB('TKOffice_UNILog_HaiQuan_UNILogistics', REPAIR_ALLOW_DATA_LOSS)
alter database TKOffice_UNILog_HaiQuan_UNILogistics SET MULTI_USER;
|
