I'm restoring several sql 2000 user databases on a sql 2008 r2 box, but sometimes I receive the following error
Error: 928, Severity: 20, State: 1
During upgrade, database raised exception 156, severity 25, state 1, address 0000000001C05A9F. Use the exception number to determine the cause.
So the error occured after the restore and while upgrading the database schema from version: 539 to 661.
However I notice that if I try to restore it again with the same statement, sometimes it goes sometimes it doesn't.
I'm not finding any 823,824 or 825 errors on SQL log.
The database compatibility level is 80.
While running Upgrade Adivsor on the database I saw 27 objects that use the older outer join sintax *=. However being that just a warning I don't think that's the cause, moreover because if I retry sometimes the restore completes succesfully.
Does anybody knows what is this?
Is this the I/O subsystem failing?
Why is this intermitent?
How do I fix it?
Thanks in advance.
View Complete Post