Sample Header Ad - 728x90

Backup database in SQL Server 2012 and restore this backup in SQL Server 2014

0 votes
0 answers
72 views
First what I do is to check consistency of database in SQL Server 2012: CHECKDB (DATABASE1) And it is ok, no errors and warnings. Next I do FULL backup and restore it on another machine with has SQL Server 2014 using SQL Server Management Studio with WITH REPLACE option. However after I run CHECKDB (DATABASE1) I receive consistency errors messages: Msg 8939, Level 16, State 98, Line 1 Table error: Object ID 293576084, index ID 67, partition ID 72057594074628096, alloc unit ID 72057594126598144 (type In-row data), page (1:5589561). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4. Msg 8928, Level 16, State 1, Line 1 Object ID 293576084, index ID 67, partition ID 72057594074628096, alloc unit ID 72057594126598144 (type In-row data): Page (1:5589561) could not be processed. See other errors for details. Msg 8976, Level 16, State 1, Line 1 Table error: Object ID 293576084, index ID 67, partition ID 72057594074628096, alloc unit ID 72057594126598144 (type In-row data). Page (1:5589561) was not seen in the scan although its parent (1:5580238) and previous (1:5589560) refer to it. Check any previous errors. Msg 8978, Level 16, State 1, Line 1 Table error: Object ID 293576084, index ID 67, partition ID 72057594074628096, alloc unit ID 72057594126598144 (type In-row data). Page (1:5589562) is missing a reference from previous page (1:5589561). Possible chain linkage problem. Msg 8939, Level 16, State 98, Line 1 Table error: Object ID 293576084, index ID 1, partition ID 72057594073645056, alloc unit ID 72057594125615104 (type In-row data), page (1:21142097). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4. Msg 8928, Level 16, State 1, Line 1 Object ID 293576084, index ID 1, partition ID 72057594073645056, alloc unit ID 72057594125615104 (type In-row data): Page (1:21142097) could not be processed. See other errors for details. Msg 8976, Level 16, State 1, Line 1 Table error: Object ID 293576084, index ID 1, partition ID 72057594073645056, alloc unit ID 72057594125615104 (type In-row data). Page (1:21142097) was not seen in the scan although its parent (1:21112030) and previous (1:21142096) refer to it. Check any previous errors. Msg 8978, Level 16, State 1, Line 1 Table error: Object ID 293576084, index ID 1, partition ID 72057594073645056, alloc unit ID 72057594125615104 (type In-row data). Page (1:21142098) is missing a reference from previous page (1:21142097). Possible chain linkage problem. CHECKDB found 0 allocation errors and 8 consistency errors in table 'TABLE1' (object ID 293576084). CHECKDB found 0 allocation errors and 8 consistency errors in database 'DATABASE1'. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (DATABASE1). Am I doing something wrong with backup restoration?
Asked by piotrassss (101 rep)
Apr 3, 2024, 08:31 AM
Last activity: Apr 3, 2024, 09:34 AM