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 |
|
golden_manish
Starting Member
13 Posts |
 Posted - 2005-04-06 : 03:26:55
|
| Hello guys,I have a very simple question.I have 10 Records in a table.I delete 4 of those reocrds. Now i want to retrieve those records, is it some way i can recover those 4 records from the transaction log?Thanks in advanceManish |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-04-06 : 03:39:32
|
| you have two options:1. Perform a point in time recovery to the moment before you deleted the 4 rows2. Use a tool like lumigent log explorer to recover the deleted data from the SQL Server tlogs.btw, both of these solutions require you to run your database in FULL logging mode. If you are running in simple mode you are SOL.-ec |
 |
|
|
|
|
|
Data Recovery