database from corrupt file?

Discussion in 'Programmer's Corner' started by kevinfry, Nov 25, 2015.

Thread Status:
Not open for further replies.
  1. kevinfry

    Thread Starter New Member

    Nov 25, 2015
    1
    0
    one of my SQL server database seems to have problem. I have tried detaching and attaching it again but getting SQL server error message 5172. It looks like my database is corrupt.
    Can anyone suggest any tips/methods that help me in extracting data from my corrupt SQL server database?
     
  2. panic mode

    Senior Member

    Oct 10, 2011
    1,318
    304
    not an database expert but... if you pick some irrational number (pi, e or whatever), represent it in binary and look at the bit stream, it will contain every piece of information one can possibly have, history and future too...;)
     
  3. mcgyvr

    AAC Fanatic!

    Oct 15, 2009
    4,769
    969
  4. MrSoftware

    Member

    Oct 29, 2013
    497
    122
    Before you do anything, make a copy of the database files and work with the copy. Now if you jack up the copy trying to fix it, you can make another copy and try again.

    If you've got backups, you might want to restore your latest backup and see what you can get from that. If there weren't many changes since the backup then that may cut down on what you have to spend time recovering.
     
  5. vpoko

    Member

    Jan 5, 2012
    258
    47
    Depending on the recovery mode of your db, you can recover by restoring a backup and then applying transaction logs to it. This won't work in simple recovery mode since no transaction logs are created.
     
  6. WBahn

    Moderator

    Mar 31, 2012
    17,715
    4,788
    Guys, this is spam. It is a tactic that we are seeing on a recurring basis. Some new member asks how to recover a corrupt file and then, a day or so later, another new member responds with a link to a third party tool to do it (we deleted that response in this thread). If people want to use the OP as a jumping off point for discussing this topic, that's fine. But have no illusions, the TS does NOT have a corrupted file that they are trying to recover, they are merely playing games aimed at deceiving the very people that they are trying to trick into becoming their customers.
     
  7. DickCappels

    Moderator

    Aug 21, 2008
    2,647
    632
    These threads are attracting more spam.
     
  8. WBahn

    Moderator

    Mar 31, 2012
    17,715
    4,788
    I don't think the threads are attracting spam, I think the thread itself consists of two spam posts plus whatever legitimate posts it attracts from members. The first post is spam, just doesn't look like it. Then a few days later the actual spam post, that was scheduled from before the original post ever arrived, is posted.

    The only way to prevent the actual spam post is to lock the thread as soon as we recognize the teaser post -- but then we run the risk of locking a legitimate post from a legitimate new user that has a legitimate problem.

    So I think the best route to go (and I could well be wrong) is to let the thread live, announce our suspicions when they arise (which gives the legitimate poster the chance to respond and say that they really do have a problem -- and if they don't it largely confirms our suspicion that the first post is an automatically generated teaser post), kill the spam post when it arrives, and announce that we did that. Ideally this will get back to the spammer and they will conclude that their tactic isn't working. That is probably too much to hope for. But at least it can still serve an educational role to let our members know what is going on and the kind of tactics that are out there so that, perhaps, they will be less likely to be suckered into doing business with anyone that starts out by deceiving their potential customers.
     
  9. DickCappels

    Moderator

    Aug 21, 2008
    2,647
    632
    That's a reasonable analysis and an excellent solution!
     
Loading...
Thread Status:
Not open for further replies.