Crap Data in Table

[AidenMc]

Hi all,
Maybe someone might be able to help me with this. We have a client and this morning they reported that their invoicing seem incorrect. when I connected onto their site, i notice that one of their tables had rubbish data in it, ie symbols etc instead of records, is there any way to recover this table.
I have tried to
1. validate database
this work and gave me no errors

2. I then reindex the specific table, again no errors reindexed fine.

I am at a lost as to what to do now except restore the table back from the day before yesterday, this is the last resort as it would mean the client will have to enter their invoices for the last two days again and they have a high volume of these

regards,

Aiden

 

[ramani]

Hi
Obviously the table is corrupt.

If you can browse the table without any index and the rubbish data is not present, you can recreate the index. However, if the table itself has rubbish.. then the table is corrupted and I dont think we can recover it that easy. If only the header is spoilt, we can fix that.

It is worth a try.. giving..

SELECT * from myBadTable INTO DBF temp
browse thru temp to find rubbish. If absent.. then zap the original table and append from temp.. which will recreate the index.



____________________________________________
ramani - (Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[craigsboyd]

Cut your losses, have the customer restore the backup and start entering the invoices. Take the time to explain to them how important a daily (even twice daily if there volume is really that high) backup is and help them set one up if they need to. Even if you are able to get the information from the table back using the method ramani suggested above you and the customer will always wonder if everything really is OK or whether there is another problem lurking in there somewhere. The backup is the safest, easiest, most reliable, fastest way to get the customer back up and running.

http://www.sweetpotatosoftware.com

 

[terosoft]

Can I add that is also important to have an updated antivirus and a good UPS at the server? Also, for extra protection, server hard disk write cache could be disabled to prevent data loss due incidental reboots or shut downs.

Gerardo Czajkowski

 

[Mike Lewis]

Aiden,

Just to add .. I agree totally with Craig. Don't waste your time trying to restore. Better to get on with the invoicing run, then make sure you have more frequent backups in place.

Once that's done, you can worry about what caused the error in the first place.

Mike

Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[jimoo]

Are they running on an older version of Novell Network? There was at least one version of Netware Client that caused this in the past. If the answer is yes - check Novell's site to see if you can find the specific article. It has been a while since I encountered this myself.



Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[AidenMc]

Hi all,
thanks for all the advice. I got the user to restore from backup and just re-enter the invoices. Went through the explanation as to why it is important to backup and have a ups, as the problem occured after a power failure,

thanks again

Aiden