sql server 事务日志备份异常恢复案例---惜分飞

DBCC CHECKDB('OLTP') WITH NO_INFOMSGS, ALL_ERRORMSGS

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 28147935764938752 (typeUnknown), page ID (1:33059984) contains an incorrect page IDinits page header. The PageIdinthe page header = (68:3276868).

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 11540680206712832 (typeUnknown), page ID (1:33059985) contains an incorrect page IDinits page header. The PageIdinthe page header = (102:6488116).

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 16888988233302016 (typeUnknown), page ID (1:33059986) contains an incorrect page IDinits page header. The PageIdinthe page header = (93:6619252).

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 16888988233302016 (typeUnknown), page ID (1:33059987) contains an incorrect page IDinits page header. The PageIdinthe page header = (93:6619252).

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 16888988233302016 (typeUnknown), page ID (1:33059988) contains an incorrect page IDinits page header. The PageIdinthe page header = (93:6619252).

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 28147836977938432 (typeUnknown), page ID (1:33059989) contains an incorrect page IDinits page header. The PageIdinthe page header = (73:6619248).

Msg 8909, Level 16, State 1, Line 1

……………………

Object ID 1961110077, index ID 0, partition ID 72057594217627648, alloc unit ID 72057594256687104 (typeIn-row data): Page (1:36535484) could not be processed. See other errorsfordetails.

Msg 8928, Level 16, State 1, Line 1

Object ID 1961110077, index ID 0, partition ID 72057594217627648, alloc unit ID 72057594256687104 (typeIn-row data): Page (1:36535485) could not be processed. See other errorsfordetails.

Msg 8928, Level 16, State 1, Line 1

Object ID 1961110077, index ID 0, partition ID 72057594217627648, alloc unit ID 72057594256687104 (typeIn-row data): Page (1:36535486) could not be processed. See other errorsfordetails.

Msg 8928, Level 16, State 1, Line 1

Object ID 1961110077, index ID 0, partition ID 72057594217627648, alloc unit ID 72057594256687104 (typeIn-row data): Page (1:36535487) could not be processed. See other errorsfordetails.

CHECKDB found 0 allocation errors and 24 consistency errorsintable'CIOMessage'(object ID 1961110077).

CHECKDB found 0 allocation errors and 17955 consistency errorsindatabase'OLTP'.

Completiontime: 2025-11-19T17:13:03.2762122+08:00

RESTORE LOG OLTP1121 FROM DISK ='D:\share\OLTP_backup_2025_11_13_030001_7745248.trn'WITH NORECOVERY

RESTORE LOG OLTP1121 FROM DISK ='D:\share\OLTP_backup_2025_11_13_060001_3581210.trn'WITH NORECOVERY

RESTORE LOG OLTP1121 FROM DISK ='D:\share\OLTP_backup_2025_11_13_090001_2856408.trn'WITH NORECOVERY

RESTORE LOG OLTP1121 FROM DISK ='D:\share\OLTP_backup_2025_11_13_120002_0713663.trn'WITH NORECOVERY

RESTORE LOG OLTP1121 FROM DISK ='D:\share\OLTP_backup_2025_11_13_150001_7305524.trn'WITH NORECOVERY

RESTORE LOG OLTP1121 FROM DISK ='D:\share\OLTP_backup_2025_11_13_180000_9123036.trn'WITH NORECOVERY

RESTORE LOG OLTP1121 FROM DISK ='D:\share\OLTP_backup_2025_11_13_210001_3663138.trn'WITH NORECOVERY

RESTORE LOG OLTP1121 FROM DISK ='D:\share\OLTP_backup_2025_11_14_000001_1605695.trn'WITH NORECOVERY

RESTORE LOG OLTP1121 FROM DISK ='D:\share\OLTP_backup_2025_11_14_030001_7280782.trn'WITH NORECOVERY

………………

RESTORE LOG OLTP1121 FROM DISK ='D:\share\OLTP_backup_2025_11_17_180001_1343952.trn'WITH NORECOVERY

Processed 0 pagesfordatabase'OLTP_1121',file'OLTP'onfile1.

Processed 10388 pagesfordatabase'OLTP1121',file'OLTP_log'onfile1.

Msg 9004, Level 16, State 3, Line 1

An error occurredwhileprocessing the logfordatabase'OLTP_1121'. If possible, restore from backup.

If a backup is not available, it might be necessary to rebuild the log.

Msg 3013, Level 16, State 1, Line 1

RESTORE LOG is terminating abnormally.

Completiontime: 2025-11-21T13:41:54.2352031+08:00