dbcc checkdb errors, or msg 601 when restoring SQL 2012 backup to SQL 2016
1
vote
1
answer
177
views
I need to move two databases, WES and WILL from a Win2012/SQL2012 instance to a Win2016/SQL2016 instance for a software upgrade. I'm using the full backup files from the SQL2012 maintenance plans. I've verified I can restore them to the original SQL2012 instance with no errors.
Restoring WES to SQL2016 reports no errors, but dbcc checkdb shows errors:
>Msg 8939, Level 16, State 98, Line 13
Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data), page (1:453). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
...etc
Restoring WILL to SQL2016 stops partway through the upgrade steps with
>Database 'WILL' running the upgrade step from version 805 to version 806.
Msg 601, Level 12, State 3, Line 2
Could not continue scan with NOLOCK due to data movement.
I thought the upgrade between versions was automatic. Is there anything else I need to do?
Asked by JeffH
(11 rep)
Feb 25, 2022, 02:24 PM
Last activity: Jul 1, 2025, 09:07 PM
Last activity: Jul 1, 2025, 09:07 PM