Search This Blog

Saturday, 8 March 2014

database has not been recovered yet - please wait and try again

Try this...

In the master database, issue the following:

sp_configure "allow updates to system tables", 1

1. update sysdatabases
set status = -32767
where dbid = id for DB <databasename>

2. checkpoint master database

3. shutdown and restart ASE Server

The database should now be in by-pass recovery mode.

4. use database <databasename>

5. dump tran database with no_log

6. update sysdatabases set status = 0

where dbid = ID for db <databasename>

9. checkpoint master

10. shutdown and restart ASE

No comments:

Post a Comment