Re: SQl restore error

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

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Eric Jensen: "SQl restore error"
Next message: Rafael Gomez: "Time Limits"
Next message: Wayne Jordan: "Expression to Complex Problem"
Maybe in reply to: Eric Jensen: "SQl restore error"
Next in thread: Dale E. Reed Jr.: "Re: Tables Question"

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
database.

-- Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com

Previous message: Eric Jensen: "SQl restore error"
Next message: Rafael Gomez: "Time Limits"
Next message: Wayne Jordan: "Expression to Complex Problem"
Maybe in reply to: Eric Jensen: "SQl restore error"
Next in thread: Dale E. Reed Jr.: "Re: Tables Question"