Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rollback
Message
From
23/06/2006 12:09:58
 
 
To
23/06/2006 03:10:12
General information
Forum:
Microsoft SQL Server
Category:
Third party products
Title:
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01131040
Message ID:
01131203
Views:
11
>Hi,
>I updated wrong data to all of the records in my table. It has been committed. My backup is about week ago. Any command or 3rd party tool that allow me to "rollback" to previous stage based on SQL transaction log?

If you are using the Full Recovery model on the database, and you can back up the transaction log since your week-old backup, you might be able to use SQL Server itself to recover the data to a point in time before before the bad data got committed.

See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2l9s.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpc_6pv6.asp

Chris
Christopher Bohling, Consultant
http://www.ChristopherBohling.com
Previous
Reply
Map
View

Click here to load this message in the networking platform