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. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart