Post reply

DB Recovery without backup

  • January 13, 2006 at 6:43 am

    #166776

    I accidentialy deleted a sql db, but I don't have a backup.

    Anyone knows how I can have it back?

    Thanks,

     

  • January 13, 2006 at 6:47 am

    #614613

    Not going to happen. About the only way is to send your hard drives to a place that recovers data from the drives. But that is very expensive and usually can't recover everything.

    Lesson to be learned.....backup frequently. The very first thing you should do when you take responsibility for a database is to back it up.

    -SQLBill

  • January 13, 2006 at 6:54 am

    #614616

    That's the point where I think MS SQL is convenient, but dangerous.

    I learned the lesson.

    Thanks, SQLBill.

     

  • January 13, 2006 at 8:14 am

    #614656

    Is the file (.mdf/.ldf) gone from the drive? Check that because if it's not, then you can get it back.

Viewing 4 posts - 1 through 3 (of 3 total)

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