Re: SQl restore error

Dale E. Reed Jr. ( (no email) )
Fri, 15 May 1998 08:34:17 -0700

Eric Jensen wrote:
> Please help... When attempting to restore the emerald databse I get the
> following error. "(SQL Server) Attempt to fetch logical page 40960 in
> database 'Emerald' belongs to ' 0' , not to object 'ALLOCATION'. I have
> also had the number 126208 instead of the one mentioned above. I have tried
> several different "dumps" both old and new. Thanks in advanced for any help.

Is this when actually restoring the database or using a restored
database? Its possible that the current database is corrupt. You
may need to drop it, recreate a new one, and then restore into the
new database. I have also seen issues where the problem is restored
(it was in the dump) and the only way to correct the issue was to
use SQL Transfer to copy the data out, and then into a known good

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |