Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bvijay_kumar
Starting Member
1 Post |
 Posted - 2006-05-04 : 03:09:21
|
| hi any body can help me in this as i have deleted the records by accidently and i want to recover the same, i have tried the options like using the free demo recovery tool nothing worked .pls help me in give some solutions to recover the deleted data. As i have tried to restore the tran log and the sytanx below RESTORE LOG db_name FROM 'E:\tranlog' WITH RECOVERY, STOPAT = 'May 03, 2006 05:00 PM' pls help me ASAP |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-05-04 : 03:14:44
|
2-3 days back same thing happen with me, and i emailed to SQL Mag i got the following reply. see if this helps you.. quote:
If you were running in full recovery mode then the data will be in the log or your log backup – there are tools that can extract this information, do a live.com search and you’ll see some products that can do this: http://www.live.com/#q=sql%20log%20data%20recovery&offset=5 Otherwise I’m afraid the data is effectively gone once the transaction commits and really gone when checkpoint takes place.
If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
 |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Recover the deleted records from table in sql2000