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

Msg 10332:SELECT permission denied on column audflags of object sysobjects, database

error:

Msg 10332, Level 14, State 1:
Server '%s%', Line 1:
SELECT permission denied on column audflags of object sysobjects, database dxpo, owner dbo

Simple resolution:

grant all on sysobjects to public

go

error
Msg 10331, Level 14, State 1:
Server '%s%', Line 1:
CREATE TABLE permission denied, database %s%, owner dbo