-
Error : 806 -- Could not find virtual page...
at SQL Server startup, in error log:
Error : 806, Severity: 21, State: 1
Could not find virtual page for logical page <number> in database 'EMGTEST'
Error : 3414, Severity: 21, State: 1
Database 'EMGTEST' (dbid 7): Recovery failed. Please contact Technical Support for further instructions.
Database 'EMGTEST' cannot be opened - it has been marked SUSPECT by recovery. The SA can drop the database with DBCC.
.....
I reset status to Emergency mode (sysdatabases.status = -32768),
run dbcc checkdb, dbcc newalloc, dbcc textall...it all looks just fine.
I also changed database status to 12 (sysdatabases.status = 12 - select into/bulkcopy and trunc. log on chkpt.) and then run dbcc checkdb, dbcc newalloc, dbcc textall again. looked just fine.
but, if I restarted server , database will be marked 'suspect' again, because of Error 806.
any ideas?
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|