How to recover updated data in sql server

Question

Post reply

How to recover updated data in sql server

Senthil Varadharajan

Mr or Mrs. 500

Points: 545
More actions
October 19, 2010 at 4:41 am

#157268

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.

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

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

Adiga One Orange Chip Points: 27284 More actions · Answer 1

Restoring from the last transaction log backup is an option

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

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 More actions · Answer 3

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 More actions · Answer 4

Hi Adiga,

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

Thnks,

Senthil Varadharajan

Senthil Varadharajan Mr or Mrs. 500 Points: 545 More actions · Answer 5

Hi GilaMonster,

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

Thnks,

Senthil Varadharajan

Senthil Varadharajan Mr or Mrs. 500 Points: 545 More actions · Answer 6

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 More actions · Answer 7

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: 1004504 More actions · Answer 8

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: 27284 More actions · Answer 9

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 More actions · Answer 10

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 More actions · Answer 11

Visit this link

I was get into the same issue and my problem solved

philips.zortzis Newbie Points: 2 More actions · Answer 12

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.