Problems with Emerald SQL Database

Anton Zur ( az@evosys.net )
Fri, 12 Dec 1997 10:09:13 +0100

Hi,

I've got a serious problem with my SQL Database.
I dropped it, installed a new device and databse.
Then I stopped the SQL Server and replaced the new created files with
the old ones and restarted the SQL Server.

Everything started fine and also Emerald itself starts, but I can't insert=
anything in
the Tables or delete anything.

e.g. if I want delete all entries in the Calls-Table that have a "Start"-e=
ntry,
it returns me the following:

Attempt to read allocation page 163840 failed either because object ID is =
not correct (0) or the page ID is not correct (0). (Message 1109)

And if I run checkdb.sql it returns me the following:

Msg 625, Level 20, State 1
Could not retrieve row from logical page 128488 via RID because the entry =
in the offset table (=3D 0) for that RID (=3D 3) is less than or equal to =
0.
Msg 2529, Level 16, State 4
Table Corrupt: Page 163840 not found
Msg 7997, Level 16, State 1
'OperatorAccess' does not contain an identity column.
Msg 7997, Level 16, State 1
'RadValues' does not contain an identity column.

Can anyone help me with that problem ?

regards, Anton
-----------------------------------------------------
Evolution Systems GmbH Mobil-Oil-Str. 42
Technical Manager 84539 Ampfing
eMail: az@evosys.net Tel: +49 8636 9830 0
WWW: http://www.esib.netFax: +49 8636 9830 99
-----------------------------------------------------