The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

After server crash getting "assertion failed 201129 ( File is shorter than expected."

Over 800GB were free on server at time of crash

Thanks for help


asked 17 Jan '12, 11:37

Randy's gravatar image

accept rate: 0%

edited 17 Jan '12, 12:59

Mark%20Culp's gravatar image

Mark Culp

Your database is corrupt; you should review the "I've got an assertion! What should I do?" document for further details. To get back up and running, you should revert to the most recent and valid backup of the database, assuming it is available.

If you do not have a valid backup copy of the database, you can try to salvage the database via Sybase Technical Support (for an additional salvage engagement fee).

"File is shorter than expected" can happen when the database file's file-system metadata has not been flushed to disk correctly and power is lost to the drive. For some Intel disk controller manufacturers on Windows, there is a registry setting that must be set in order to have disk flushes happen correctly.

You should review our SQL Anywhere I/O whitepaper to ensure that your operating system environment is set up to store files correctly (at times of power loss / system restart / etc.).

If you are using NTFS on Windows, you should also be aware of the recent comments Microsoft has made regarding "NTFS file metadata integrity" on current versions of Windows.

permanent link

answered 17 Jan '12, 12:53

Jeff%20Albion's gravatar image

Jeff Albion
accept rate: 24%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 17 Jan '12, 11:37

question was seen: 7,011 times

last updated: 17 Jan '12, 12:59