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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-05 : 08:34:30
|
| abdul writes "deari have deleted some records accidently from the table. Now i want to recover that records, is it possible from transaction log. if yes, let me know howThanks" |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-06-05 : 10:09:01
|
| If you have a product like Log Explorer (http://www.lumigent.com/) you can recover the records from the transaction log. Otherwise you'll need to take a transaction log backup, temporarialy restore a copy of the database under a different name and restore the transaction logs up to a point in time before the delete. Then you can transfer the records back into the real database and drop the temporary one.Jeff Banschbach, MCDBA |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-05 : 12:20:13
|
| If you have a full backup (Prior to the deletion) and you are in full recovery mode. Simply made a tlog backup, and recover to a point in time just before you made the deletions.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
recover the deleted records