Revisions to SQL Server detected a logical consistency-based I/O error: incorrect pageid on RESTORE

Notice removed Draw attention by Henrik Staun Poulsen

occurred Mar 5, 2017 at 17:57

Bounty Ended with Remus Rusanu's answer chosen by Henrik Staun Poulsen

occurred Mar 5, 2017 at 17:57

added 48 characters in body

Source Link

edited Feb 28, 2017 at 7:09

Henrik Staun Poulsen

2.2k
2
23
39

The real question is; what should I do next?

Notice added Draw attention by Henrik Staun Poulsen

occurred Feb 27, 2017 at 21:38

Bounty Started worth 50 reputation by Henrik Staun Poulsen

occurred Feb 27, 2017 at 21:38

Finished dbcc

Source Link

edited Feb 27, 2017 at 21:37

Henrik Staun Poulsen

2.2k
2
23
39

DBCC CHECKFILEGROUP is currently running. Finished with out errors.

new error message

Source Link

edited Feb 27, 2017 at 11:46

Henrik Staun Poulsen

2.2k
2
23
39

Update: We did another backup and restore from the old server to the new server. This time we got this message:

Could not redo log record (2456609:4261461:64), for transaction ID (28:972770238), on page (48:211577379), allocation unit 72058359886184448, database 'DataWarehouse' (database ID 7). 
Page: LSN = (2456609:3279166:236), allocation unit = 72058351460417536, type = 20. Log: OpCode = 2, context 5, PrevPageLSN: (2456609:4250688:2). 
Restore from a backup of the database, or repair the database.

I have tried to Google this message, but the only advise I can find is to restore the database (which is what I'm trying to).

Update: We did another backup and restore from the old server to the new server. This time we got this message:

Could not redo log record (2456609:4261461:64), for transaction ID (28:972770238), on page (48:211577379), allocation unit 72058359886184448, database 'DataWarehouse' (database ID 7). 
Page: LSN = (2456609:3279166:236), allocation unit = 72058351460417536, type = 20. Log: OpCode = 2, context 5, PrevPageLSN: (2456609:4250688:2). 
Restore from a backup of the database, or repair the database.

I have tried to Google this message, but the only advise I can find is to restore the database (which is what I'm trying to).

add image on the numbers

Source Link

edited Feb 17, 2017 at 7:45

Henrik Staun Poulsen

2.2k
2
23
39

Loading

added dbcc page

Source Link

edited Feb 16, 2017 at 8:08

Henrik Staun Poulsen

2.2k
2
23
39

Loading

added error log output

Source Link

edited Feb 16, 2017 at 7:54

Henrik Staun Poulsen

2.2k
2
23
39

Loading

version and page verify

Source Link

edited Feb 15, 2017 at 21:02

Henrik Staun Poulsen

2.2k
2
23
39

Loading

Tweeted twitter.com/StackDBAs/status/831893791837663233

occurred Feb 15, 2017 at 15:51

edited tags

Link

edited Feb 15, 2017 at 14:54

Hannah Vernon ♦

70.5k
22
177
321

Loading

edited body

Source Link

edited Feb 15, 2017 at 13:52

Henrik Staun Poulsen

2.2k
2
23
39

Loading

Source Link

asked Feb 15, 2017 at 13:47

Henrik Staun Poulsen

2.2k
2
23
39

Loading

Stack Exchange Network

Return to Question