SQL Compare error message too vague
xpil
Posts: 7
When running the mapping step, it may happen that SQL Schema Compare detects a severe error and stops further processing. It displays the details of the error but without indicating whether it applies to the source or the target server.
The error is:
"SQL Server detected a logical constency-based I/O error: incorrect pageid (expected: xxxxxxx; actual: yyyyyy). It occured during a read of page (a:bbbbbbb) in database ID zz at offset 0x123471289304781290374 in file 'E:path omdffile.mdf'. Additional messages in the SQL Server error log or system event may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately."
As can be clearly seen, there is no mention of which server this error applies to. It would be desirable to see this fixed in some future release.
The error is:
"SQL Server detected a logical constency-based I/O error: incorrect pageid (expected: xxxxxxx; actual: yyyyyy). It occured during a read of page (a:bbbbbbb) in database ID zz at offset 0x123471289304781290374 in file 'E:path omdffile.mdf'. Additional messages in the SQL Server error log or system event may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately."
As can be clearly seen, there is no mention of which server this error applies to. It would be desirable to see this fixed in some future release.
Comments