Post reply

Getting Truncated data back

  • September 26, 2011 at 4:09 am

    #390471

    Hi Guys,

    How to retrieve the data's back if we truncated the table..?

    Is it possible to do so?

    Thanks

    Thanks,
    Charmer

  • September 26, 2011 at 4:14 am

    #1386349

    If you have same old Backup u can restore that. other wise some 3rd party tools are there, through u can do that.

  • September 26, 2011 at 4:54 am

    #1386359

    Hi,

    Whats the difference between delete and truncate then..?

    i hope this is the difference...i have read at some where that

    restoring the data back is possible if we truncate the table where we can't if we delete the table....

    so we can't able to get the data's back? can't we?

    Thanks

    Thanks,
    Charmer

  • September 26, 2011 at 5:01 am

    #1386363

    prakash 67108 (9/26/2011)

    Hi,

    Whats the difference between delete and truncate then..?

    i hope this is the difference...i have read at some where that

    restoring the data back is possible if we truncate the table where we can't if we delete the table....

    so we can't able to get the data's back? can't we?

    Thanks

    if you have a backup then you can get the data back regardless of delete or truncate.. if you dont have a backup then you can't..*

    *(aside from possibly using a log-reader )

  • September 26, 2011 at 5:05 am

    #1386366

    Thanks for the comments given

    is it possible to retrieve the crashed database back?

    Thanks,
    Charmer

  • September 26, 2011 at 5:10 am

    #1386367

    The main difference is how the statements are logged. Both are logged so that they can be rolled back.

    Obviously that has no effect on a previous backup.

  • September 26, 2011 at 5:11 am

    #1386368

    Hi,

    is it possible to retrieve the crashed database back?

    Thanks

    Thanks,
    Charmer

  • September 26, 2011 at 5:13 am

    #1386371

    prakash 67108 (9/26/2011)

    Hi,

    is it possible to retrieve the crashed database back?

    Thanks

    do you have a backup?

    you need to answer this in order for us to really help.

  • September 26, 2011 at 5:16 am

    #1386374

    nope...i don't have

    Thanks,
    Charmer

  • September 26, 2011 at 5:18 am

    #1386379

    prakash 67108 (9/26/2011)

    Thanks for the comments given

    is it possible to retrieve the crashed database back?

    Restore from backup or redo everything you did to get it to the point where it was. Not trying to be useless or anything but those are your only 2 options.

  • September 26, 2011 at 5:20 am

    #1386380

    prakash 67108 (9/26/2011)

    nope...i don't have

    can you let us know a bit more about the problem, because you say you want truncated data back, and then you say your db is crashed.

    could you please elaborate, because some 'crashed' databases can be recovered.

    but without a backup its not looking good

  • September 26, 2011 at 5:31 am

    #1386388

    Define 'crashed'

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 26, 2011 at 5:34 am

    #1386390

    Thankyou

    Thanks,
    Charmer

  • September 26, 2011 at 5:41 am

    #1386393

    i don't know what exactly the problem is ? actually one of my friend asked me what is the way to retrieve the table if it is crashed out..?

    i don't have any idea about that..so i would like to know how to do that if possible...

    Thanks,
    Charmer

  • September 26, 2011 at 5:44 am

    #1386394

    prakash 67108 (9/26/2011)

    i don't know what exactly the problem is ? actually one of my friend asked me what is the way to retrieve the table if it is crashed out..?

    i don't have any idea about that..so i would like to know how to do that if possible...

    You still have some hope, but you need to clearly define what "crashed" means.

Viewing 15 posts - 1 through 15 (of 25 total)

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