Re: [Emerald] Yet another SQL problem

Dale E. Reed Jr. ( (no email) )
Thu, 29 Jul 1999 09:36:02 -0700

Ed Miller wrote:
> Anyone know what it is and or how to fix it. The working copy of the dB is
> the only copy I have
> all backups are bad. This seems to have been in the dB for a while. April
> 15, 1999
> I have removed all records before April 10, 1999 with no problem.
> I am reluctant of removing any records past the April 115, 1999 date in fear
> of destroying the table or the dB.
> I need advice from the SQL experts out there.

I would create a clean database (blank) and do a DB Transfer from your
current DB to the new (blank) one. This will copy just the data, and
not any errors in your current DB. I've had to do this a couple of
times when something in a DB was corrupt, and DBCC wouldn't/couldn't
fix it.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: