SQL Log Rescue – Undo for SQL Server

– July 31, 2009Posted in: Articles, General

Came across this product again today to help with a particular need. I’ve used Red Gate products before at another employer and loved them. However, I never realized the SQL LogRescue product. On top of that, it is a free tool.

Kudos to the Red Gate folks for making this tool available to the SQL Server community. I know, your saying that there are other ways of dealing with transaction logs, and you’re right. But what I like about the SQL Log Rescue is the quick intuitive way to essentially create an audit trail, review the transactions in question and undo various transactions individually.

Now the downside….it is only for SQL Server 2000. I know. that’s two SQL versions ago. So hear is my question.

What are you using to handling transaction log, transaction restore and such? Let me know, add a comment.

Popularity: 2% [?]

Tags: sql, sql server, tools, transaction log

About Tom

Christ follower, husband, father, technology and photography enthusiast. Attempting to live life out as a light in this world and stumbling at times in this fallen world. Got a topic you want to have me look into? Did I miss something in a post? Let me know. Just add a comment below.

2 Comments

Mol

Posted September 21, 2009 at 5:19 AM

We have te same problem at this moment.
We lost some data on a sql server 2005 db and want to undo the last sql server transactions.
Did you get any respons on the question you asked on this forum ?
Tom

Posted September 23, 2009 at 7:22 AM

No responses as far as other tools from folks.

Found the Apex SQL Log tool. Not cheap but you might try their trial and see if it does what you want. http://www.apexsql.com/sql_tools_log.asp

Additionally, I’ve read some articles referring to these:

Quest LiteSpeed – Log Reader

Quest Toad – SQL Log Reader