Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
ann
Posting Yak Master
220 Posts |
Posted - 2009-09-30 : 09:54:48
|
So I accidently updated a bunch of records that I should not have....Other than a backup, is there anyway I can get back the old data, as in transaction log? |
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-09-30 : 11:43:56
|
you can try to use Lumigent's Log Explorer, but the database would need to be in FULl recovery mode. Otherwise, the log entries are long gone. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-30 : 12:13:30
|
And you would need to use the log explorer before the next transaction log backup.--Gail ShawSQL Server MVP |
|
|
X002548
Not Just a Number
15586 Posts |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-30 : 17:07:21
|
quote: Originally posted by X002548 What's wrong with a backup?
Nothing, if you have one....--Gail ShawSQL Server MVP |
|
|
ann
Posting Yak Master
220 Posts |
Posted - 2009-09-30 : 18:20:03
|
Right - the "oops" happened after a backup was done |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|