January 24, 2011 at 11:08 am
Absolutely right.
CEWII
January 25, 2011 at 7:54 am
GilaMonster (1/24/2011)
Unless you had a trace or trigger present when the changes were made, you cannot go back and get details of what happened.
Not true. If you have all the transaction log backups and the full backup(s) they go with ApexSQL has a recovery tool that can reconstruct all DML actions (and even script out the DML and/or an UNDO script). Tell them TheSQLGuru sent you. 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 25, 2011 at 7:58 am
TheSQLGuru (1/25/2011)
GilaMonster (1/24/2011)
Unless you had a trace or trigger present when the changes were made, you cannot go back and get details of what happened.Not true. If you have all the transaction log backups and the full backup(s) they go with ApexSQL has a recovery tool that can reconstruct all DML actions (and even script out the DML and/or an UNDO script).
Except that a tran log read is not going to get you all queries run (as discussed above ;-)), just the changes made. OP wasn't clear whether he wants all changes (as in title) or all queries run (as in first post).
The former, sure (with an expensive 3rd party tool) assuming full recovery and no deleted log backups.
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
January 25, 2011 at 9:15 am
ahh. I took "...manipution have done in sql..." to mean DML only. 🙂
BTW, I consider $1500 (list) VERY inexpensive when it comes to being able to find/unwind "holy SH1T..." updates/deletes in a production system. :hehe:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply