Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rollback
Message
De
23/06/2006 12:09:58
Chris Bohling
Myers and Stauffer LC
Shawnee, Kansas, États-Unis
 
 
À
23/06/2006 03:10:12
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Produits tierce partie
Titre:
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01131040
Message ID:
01131203
Vues:
12
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform