Skip to Content

'suspect' Database state

Jan 01 at 10:34 AM


avatar image
Former Member

Dear All

after restore my sybase DB , it can't start up give me the below error :

Database 'XXX' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the ASE errorlog for information as to the cause.

i detect that log is full 100% , when i try to truncate it give me the same issue

any help

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tilman Model-Bosch
Mar 08 at 02:48 PM

A successfull restore and or a log full situation does not lead to a suspect database. Also - you cant opena suspect database to performa a DUMP TRAN command.

For the root cause you will have to search the ASE error.log - at some point in time some eror happened why it was marked suspect.

Was there some fatal error during the restore of the database ?

10 |10000 characters needed characters left characters exceeded