Just wondering, if someone faced the same issue.
We have got a SQL Server 2008 R2 (10.50.2789) and SQL Server 2014 (12.0.2000) and there is a process of backup on MSSQL Server 2008 R2 and restore on MSSQL Server 2014. Everything was going fine, till today. DB gets correctly (without error/warning) backed up, restored and upgraded. DBCC CHECKDB on source is ok and DBCC CHECKDB just after restore fails on the target.
I would raise a ticket to Microsoft, if it wasn't the most confidential db in the house ;)
Details (edit):
1) Both machines are virtual boxes source is on a decent traditional san, target on full flash array beast. Both are serving other servers with no consistency errors.
2) Yes, fresh backup helped, it was our first try. But why, @#$@@!!, the corrupted one can restore on sql 2008 r2 without corruption. And not on 2014.
3) 'Exact' errors were couple of following in two tables. `Object ID .., index ID 1, partition ID .., alloc unit ID ..(type In-row data). Page (1:..) is missing a reference from previous page (1:..). Possible chain linkage problem.
Object ID .., index ID 8, partition ID .., alloc unit ID ..(type In-row data), page (1:1116376). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 2057 and -4.`
Aucun commentaire:
Enregistrer un commentaire