on 2015 Jul 20 3:44 AM
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
Request clarification before answering.
User | Count |
---|---|
74 | |
30 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.