Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Roll forward
Message
From
02/03/2000 11:04:26
 
 
To
02/03/2000 06:19:43
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Title:
Miscellaneous
Thread ID:
00336285
Message ID:
00340571
Views:
21
>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

Thanks

Gar
Thanks

Gar W. Lipow
Previous
Reply
Map
View

Click here to load this message in the networking platform