[Emerald] Problem with Emerald Database

=?iso-8859-1?Q?S=E9rgio_Ricardo_Carlos?= ( sergiorc@saga.com.br )
Fri, 11 Dec 1998 10:21:00 -0200

Fellows,

After creating one MBR (I'm on testing), use it to authenticating
sucessfully I had my Emerald Database considered suspect by SQL Server. The
message was:

Msg 926, Level 14, State 1
Database 'Emerald' cannot be opened - it has been marked SUSPECT by
recovery. The SA can drop the database with DBCC.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking Emerald
Msg 926, Level 14, State 1
Database 'Emerald' cannot be opened - it has been marked SUSPECT by
recovery. The SA can drop the database with DBCC.
Msg 2520, Level 16, State 3
Database named Emerald not found; check Sysdatabases
Msg 926, Level 14, State 1
Database 'Emerald' cannot be opened - it has been marked SUSPECT by
recovery. The SA can drop the database with DBCC.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Actions not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Charges not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named ClassDates not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Classes not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Credits not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Domains not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named ExternalSystems not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named ExternalTrans not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Groups not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Incidents not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named InvoiceItems not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Invoices not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Mail not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named MasterAccounts not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named OperatorAccess not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named RadATConfigs not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named RadConfigs not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named RadValues not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Rates not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Reports not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Scripts not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named Servers not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named SubAccounts not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.

This one was given by Event Viewer

Error : 3414, Severity: 21, State: 1
Database 'Emerald' (dbid 6): Recovery failed. Please contact Technical
Support for further instructions.

Can I have some help here, this is the release I'm planning to install in
our client. I'm using:

Emerald Admin 2.5.228
Emerald Client 2.5.207
Radius 2.5

Thank you,

Sérgio Ricardo

SAGA Sistemas e Computadores S/A
Av Rio Branco, 1 / Sala 1503
Rio de Janeiro
(021) 550-8537

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html