cancel
Showing results for 
Search instead for 
Did you mean: 

Assertion 200505 during mass import

MCMartin
Participant
2,581

I created a new database and imported data from a CSV file. After 90 Mio rows the database has a size of 57GB and throwed the following error:

ERROR Assertion failed: 200505 (16.0.0.2076) Checksum failure on page 7066120

At the time of the assertion there was no other warning or error message in the event log. The used file system is a relatively new SSD which showed so far no suspicious behavior and is still in good condition. The S.M.A.R.T. infos show no problems at all. The assertion occured during an increase of the database file.

Is this a false alarm? Can I double check the healthyness of the database file, or do I have to start the import all over again?

=> Update

Obviously the database is really broken, when I try to start it the following error occurs: "...is larger than expected" and then
ERROR Assertion failed: 201865 (16.0.0.2076) Checkpoint log: Invalid pages at 0x6bd208 and 0x6bd209

Accepted Solutions (0)

Answers (0)