RE: Consolidation problems

Ronnie D. Franklin ( )
Sun, 4 Jan 1998 14:17:56 -0600

> First, check your log on your Emerald Database. Typically it needs
> to be about 20% of the size of your calls table FREE in order to
> finish the delete. When you did a "DeleteCalls 1" again, did it give
> the same error?

Data Size 250 Available 194

Log Size 150 Available 114

Yes, the same error was generated when I did DeleteCalls 1 again. Also, I
have to start and stop SQL and then it goes through the recovery process.

> The other thing you might want to do is rebuild all the indexes on
> your Calls table.

How do I rebuild the indexes????