Link to home
Start Free TrialLog in
Avatar of Sandy Kalugdan
Sandy KalugdanFlag for United Arab Emirates

asked on

Error in Sybase Database... Help urgently needed!!!

I'm running a ASA 6.0.  This is what I have,

star.db
star.log
star.mlg

When I try to run the network server, it gives me this error

"internal database error **ERROR** Assertion faile 201117
Attempt to close a file marked as dirty -- transaction rolled back

Please help me with this problem... I really need to have this database back online.
ASKER CERTIFIED SOLUTION
Avatar of DaniPro
DaniPro
Flag of Italy image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sandy Kalugdan

ASKER

It looks like it solved the problem. I just need to validate the database and the points is yours my freind.

Try to convert a log file to SQL with "translate log" utility in Sybase Central, then delete the file .log and .mlg, start the database engine with the recovery switch (-f), finally start the network server and execute the file SQL generate.