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 |
|
Onamuji
Aged Yak Warrior
504 Posts |
 Posted - 2002-05-17 : 08:35:45
|
| Ok so all inserts and updates occurr in the transaction log ... I've heard things like you can rollback to an instance in time ... is it possible to rollback to a certain set? or what? I lost data and need to get it back ... ahhhh ;-) Any help would be appreciated... |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-17 : 08:42:35
|
| Log Explorer will let you rollback to a certain point, you can get the software at http://www.lumigent.com |
 |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-05-17 : 09:32:19
|
| I'm not sure if I'm getting it right but you can restore a DB from a TL to a certain point using the keyword STOPAT. The only catch is that you must have a usable DB and TL backup (it usually works with the differential backup). Look it up in BOL (RESTORE-described). |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-17 : 09:37:21
|
| I was thinking the same thing, but that's not going to give you a rollback to a certain SET of data, but will give you ALL the data as it was at that time. Plus you can't skip over certain transactions with a RESTORE. And if you didn't take a log backup immediately after the transaction completed, then it's not that helpful. |
|
|
|
|
|
|
!URGENT: Transaction Log