The backup file is corrupt and cannot be restored. It was a huge backup, about 3G. Well, tried to re-do the backup, then did another restore and it was good.

Lession Learned: Never rely on the single source backup from stsadm.