Re: Calls problem
Dale E. Reed Jr. ( (no email) )
Sun, 13 Apr 1997 02:28:58 -0700
Josh Hillman wrote:
>
> Any idea how to deal with this statement from ISQL/w??
>
> 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.
I would start with a "dbcc CheckDB(Emerald)" and also a "dbcc
CheckAlloc(Emerald)".
See if they return any errors.
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com