December 2, 2010 at 1:13 pm
I was truncating the leading zero's from a column and used an old script and missed changing the from field and consequently ended up coping the name column to the acctnum column. I need to roll back the changes, it that possible? I'm going to continue to look through the archives but I really would appreciate the help.
December 2, 2010 at 1:59 pm
If you did not start an explicit transaction (BEGIN TRANSACTION) before you ran the update, you cannot roll back. If you don't start a transaction, SQL commits each statement as it completes
I hope you have a backup from before you did the update. Full recovery model, full backups and tran log backups would be the best.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 2, 2010 at 3:11 pm
I've decided that a point in time restore and copy the data back to the original file. Anything special I should look for? This is a production table that is still getting updates. I was going to copy the correct data for that field by using the index from the restore and update the original table. Am I on the right track?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply