Post reply

Get Data From Corrupted Table

  • March 26, 2004 at 6:08 am

    #84653

    Hello,

    How could I get data from corrupted table? I don't have backup database. Do u have any idea? Help!!!

  • March 26, 2004 at 6:25 am

    #500624

    Did you try to fix the table?

    Check DBCC CHECKTABLE in BOL. Try several times with REPAIR_REBUILD, because it may not work in the first time.

  • March 26, 2004 at 8:19 am

    #500662

    If not then you will have to do a restore of the last good full backup and then apply TL log backups if you have them (which if set to full recovery model and have truncated you can make now). Test somewhere rolling forward to a point before the corruption and you should be able to recover most if not all. Otherwise no way I know of id the repair fails to work.

  • March 28, 2004 at 11:14 pm

    #500830

    Thanks for reply. I use DBCC and fixed the problem. but some data lost. how do u know when the table will be corrupted? Thanks.

  • March 29, 2004 at 5:26 am

    #500843

    There is no deffinitive answer to that. It can be corrupted multiple ways. Any idea how it occurred this time? If not I suggest using chckdisk utility to check the hard drives to ensure there isn't a bad sector where your data is sitting. If you do then that is half the battle.

  • March 30, 2004 at 4:31 am

    #501034

    I mean hey.... No Backup?

    I'd fix that "hole" pretty fast.


    __________________________________
    Searching the KB articles is like
    picking your nose. You never know
    what you'll find.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply