14
Database '%.*s' has not been recovered yet - please wait and try again.
This error occurs during the database recovery phase of Adaptive Server startup when you try to access a database for which recovery has not yet been completed. It can also occur if the database was marked suspect due to an earlier problem.
If the database has been marked suspect by an earlier problem, this is a serious error and must be corrected if you want to access your database again.
The time it takes to recover a database depends on:
The number and size of transactions that must be committed or rolled back
The amount of memory
Determine whether the recovery phase of the database has completed:
Examine your Adaptive Server error log
Execute the following command twice, 20 seconds apart, to help you determine if the databases are still undergoing recovery.
> select * from master..sysprocesses where status ="background"
When you receive the query’s output, check whether <physical_io> is increasing over time.
A “background” status does not always
indicate that the process is executing a recovery. This status can
also indicate that tasks such as a threshhold procedure or Replication
Agent (for example) are running.
If the database is still being recovered, wait until recovery is complete and then try to access the database.
If you are still unable to access the database and the database has been marked suspect because of an earlier problem, determine what the earlier problem was by looking at the Adaptive Server error log. Follow the instructions in this manual for recovering from that error. If no instructions exist, call Sybase Technical Support.
Before calling Sybase Technical Support, have the information listed in “Reporting errors” available, including the output from:
select * from master..sysusages
select dbid, name, status from sysdatabases
All versions
