• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 588
  • Last Modified:

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.
0
Sandy Kalugdan
Asked:
Sandy Kalugdan
  • 2
1 Solution
 
DaniProCommented:
Try to delete your star.log and star.mlg and start your database with recovery switch:

dbeng6.exe -f star.db

this command open and close the database engine; then start network server
0
 
Sandy KalugdanSystems AdministratorAuthor Commented:
It looks like it solved the problem. I just need to validate the database and the points is yours my freind.

0
 
DaniProCommented:
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.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now