Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Roll forward
Message
From
02/03/2000 06:19:43
 
 
To
23/02/2000 15:41:07
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Title:
Miscellaneous
Thread ID:
00336285
Message ID:
00340452
Views:
23
Gar,

>In the documentation on transaction log backups, it looks like using a transaction log is straightforward when combined with a database backup.That is first you restore the database (full or full+differetial) then apply the transaction log backup. (If this is not as easy as it sounds please comment).

>But what I don't see anything on is how you can use the transaction log to undo a single transaction which has been committed. Suppose, for example someone did an update with no where clause - wiping out a column of data? A transaction log for that update exists. How do we use the transaction log to get the data back for that column?

If you know the time that the update was committed, you can restore the final transaction log up to a point in time using the STOP AT clause.

Hope this helps

Cheers
Steve Lea
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform