as i have done the study of a suspect database, I came across various methods of marking a database as "SUSPECT". But whenever i marked a database as "SUSPECT" and restarted the server, it automatically resets the database status and makes the database "ONLINE".
I want to simulate the condition for a database which is marked "SUSPECT" and the SYBASE is not able to recover from the state. So that after a DB is marked "SUSPECT" then I would login as Super User and try to recover from the state.
So, plz if anyone has any proposed scenario in which case the DB is marked "SUSPECT" and we have to recover from it through manual intervention....