Case 1 – Corrupt user database

You received a ticket that an application doesn't work anymore and crashes when trying to retrieve information.

The application works with a database named crashdb. It is up to you to fully recover the database. There will be a database dump crashdb.dmp and one transaction log dump crashdb_1.ldp in the directory /opt/sybase/dump. After the last transaction log dump data has been modified. When you select the information from the table mytable the result will be as follows:

1> select * from crashdb..mytable
2> go
id          value
----------- --------------------
           1 a
           2 b                   

(2 rows affected)

 

Comments are closed.