How to recover updated data in sql server

  • Senthil Varadharajan

    Mr or Mrs. 500

    Points: 545

    Hi,

    how to recover the updated datas in sql server 2005? Transaction block is not used at the time of Update statement.

    Thanks & Regards,

    Senthil Varadharajan.

  • Adiga

    One Orange Chip

    Points: 27224

    Restoring from the last transaction log backup is an option

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • Gail Shaw

    SSC Guru

    Points: 1004474

    Restore from backup.

    Restore the last full backup as a new DB. Restore transaction log backups up until the time of the update.

    Bring the new DB online

    Copy the data back to the original DB.

    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
  • Dugi

    SSCoach

    Points: 17998

    Can you describe your problem more what happened and what are you trying to do ...!!! However if you have backup you can restore it ...!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Senthil Varadharajan

    Mr or Mrs. 500

    Points: 545

    Hi Adiga,

    Can you explain me how to restore from the transaction log.

    Thnks,

    Senthil Varadharajan

  • Senthil Varadharajan

    Mr or Mrs. 500

    Points: 545

    Hi GilaMonster,

    Can you explain me how to restore from the transaction log.

    Thnks,

    Senthil Varadharajan

  • Senthil Varadharajan

    Mr or Mrs. 500

    Points: 545

    Hi Dugi,

    While running the update statement, missed to select the where condition. So i need to restore data using the transaction logs. Can i know the process to retrive it.

    Thnks,

    Senthil Varadharajan.

  • Dugi

    SSCoach

    Points: 17998

    Senthil Varadharajan (10/19/2010)


    Hi Dugi,

    While running the update statement, missed to select the where condition. So i need to restore data using the transaction logs. Can i know the process to retrive it.

    Thnks,

    Senthil Varadharajan.

    Well, the GilaMonster said how to do that from the transaction log...!? Tell us if it helpful for you!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Gail Shaw

    SSC Guru

    Points: 1004474

    Senthil Varadharajan (10/19/2010)


    Hi GilaMonster,

    Can you explain me how to restore from the transaction log.

    I explained to you how to restore from backups, including a transaction log backup.

    If you mean without a backup, you don't. You can buy a tool that might allow you to do that, under certain circumstances, but said tool retails for over $1000, so it's not exactly a cheap fix and it won't always work.

    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
  • Adiga

    One Orange Chip

    Points: 27224

    Senthil Varadharajan (10/19/2010)


    Hi Adiga,

    Can you explain me how to restore from the transaction log.

    Thnks,

    Senthil Varadharajan

    Hi Senthil,

    This KB article explains how to restore from transaction log backups.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • mimran18

    SSC-Addicted

    Points: 451

    Hi,

    SQL server keeps log for every transation.So you can recover your modified data from the log as well without backup.Here is the artcile, that can explain , how to do it.

    http://raresql.com/2012/02/01/how-to-recover-modified-records-from-sql-server-part-1/

    MI
    http://raresql.com

  • eng.shahan

    Newbie

    Points: 7

    Visit this link

    I was get into the same issue and my problem solved

  • philips.zortzis

    Newbie

    Points: 2

    SQL Server performs various serious operations and hence it’s very much likely to get corrupted. Few most frequent causes of errors are as follows,

    • Sudden shutdown.

    • Link or network failure while performing any task.

    • Database invalid file header

    • Bad sector occurrence in the storage media.

    • Happening of memory error or shortage

    • Inaccessibility of partition or drivers.

    • Media damage or corruption

    • Transactional Deadlock of MS SQL database.

    • Unknown errors like “0x80070218”, “CRC error”, SQL error 5171”, “MS SQL Webadmin error” or similar.

    • Malfunctioning of hardware

    Once your MS SQL server database gets corrupt it is really very difficult to repair it and restore data from it.

    If you have available back-up then it’s easy to restore database objects.

    But in case you don't have any backup then to repair corrupt SQL database and recover its data some third party repair tool must be used. I would suggest you to try SQL Repair Tool[/url]. This tool scans the damaged database and repairs to recuperate inaccessible objects in MDF and NDF database files. It recovers tables, keys, views, stored procedures, triggers, indexes, deleted records etc.

Viewing 13 posts - 1 through 13 (of 13 total)

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