Database Recovery on Server startup

[unknown]

Hi all,

Have a database which fails to recover to completion on ASE
startup. Recovery of the database gets to this point:

03:00000:00012:2006/07/05 06:21:50.07 server Undo pass for
database 'MY_DB': 245280 records done (99%); 14 records
left.

It has been so for close to 24hrs now....with no progress
The database siz is less than 2GB.

How do i recover it???

thax

martin

[unknown]

if you have latest dump and transaction try out for bypass recovery.

set the status flag -32768. in sysdatabases for the DB and reboot ASE.. ASE
will not try to recover the DB

load the dump and tran accordingly.

Thanks

Post by unknown
Hi all,
Have a database which fails to recover to completion on ASE
03:00000:00012:2006/07/05 06:21:50.07 server Undo pass for
database 'MY_DB': 245280 records done (99%); 14 records
left.
It has been so for close to 24hrs now....with no progress
The database siz is less than 2GB.
How do i recover it???
thax
martin