select calldate, nasport from calls
where calldate > "Apr 1 1997"
(lots of calls records for ports 20101 - the next line)
Apr 11 1997 1:06AM 20105
Msg 605, Level 21, State 1
Attempt to fetch logical page 4053 in database 'Emerald' belongs to object
'0', not to object 'Calls'.
The SQL Server is terminating this process.
This is what I get after restoring the latest backup of the Emerald db from
a diskdump that runs everynight at 3am.
Incidentally, this seems to coincide with the port problem in the Calls
table that I had mentioned in my previous message (pasted below). I
restored the db from the dump at 4/11/97 3am AFTER writing the message
below.
> This is the second time this has happened and I still have no idea what
> causes it or how to fix it. My Calls table (SQL) is missing records for
> ports 6 through 43 and is missing most of 44 as well. They were all
there
> yesterday but they're all gone now. These ports are no longer being
> updated in the Calls table, though the CallsOnline view displays all 48
> ports.
>
> ??????
>
> Ascend Max 4004 5.0Ai4
> SQL Server 6.5
> Emerald 2.1.11
> Radius .60 (service)
Which db do I use??? It seems that both are screwed up somehow.
Thanks,
Josh Hillman
hillman@talstar.com