Error assertion failed: 31110 - file shorter than expected

Hi all,

my pc crashed and we lost the drive, we had a backup(network app not sybase) of our db and db.log file that msut have been taken while the dbeng was running. When I try and start sybase up again I get the error message :

Error assertion failed: 31110 - file shorter than expected.

I have tried starting the db with out the log file with no success, as well as dbvalid, using asa 7. Getting nowhere very fast with this!

thanks

LVL 12
deanvanrooyenAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed, with points refunded (150)

Computer101
E-E Admin
0
 
deanvanrooyenAuthor Commented:
ps when I try and start sybase with the db and log file that was taken with the backup
0
 
dgroscostCommented:
Try starting off with a new log file.  If that doesn't work, try this:

Dbstart file.db -ho
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
deanvanrooyenAuthor Commented:
I'll try that -ho, I have tried without a log using -f which has worked in the past but I think the issue is with the db file and not the log...
0
 
deanvanrooyenAuthor Commented:
I tried that as well with dbeng as well as dbstart and I still get the assertion.

the exact messages in dbstart are:
2048k of memeroy used for caching
Database recovery in progress
    Last checkpoint "on the day it last ran ok"
    Checkpoint log...

and then the message box:
Error assertion failed: 31110 - file shorter than expected


any other ideas thanks... I have also tried dbvalid and unlaoding the db with no success
0
 
dgroscostCommented:
If the -ho option doesn't work, try to apply and log files you have to backup databases.  If you can't start it, you can't reload it.  Might be out of luck...
0
 
deanvanrooyenAuthor Commented:
I think I am out of luck here,

I will leave this open for a bit longer as possibly one of the sybase techies might read this, they have resolved this on the sybase site but to view the solution I need to have a support contract with them :(
0
 
deanvanrooyenAuthor Commented:
how do I refund?
0
 
deanvanrooyenAuthor Commented:
please close this
0
All Courses

From novice to tech pro — start learning today.