Solved

SQL Server 2005 Transaction Log Viewer/Explorer

Posted on 2008-10-18
3
6,000 Views
Last Modified: 2012-05-05
We've been using a SQL server 2000 transaction log analysis tool called SQL Log Rescue by RedGate.  It is free.  We upgraded to SQL server 2005 and the tool does not support it.  Have not been able to find another tool like it for 2005, besides ApexSQL Log, which is too expensive for us, we're a small shop.  Are there any free or low cost tools out there for SQL server 2005 transaction log analysis?
0
Comment
Question by:arms145
3 Comments
 
LVL 23

Accepted Solution

by:
adathelad earned 500 total points
ID: 22749498
Hi,

There aren't any free tools AFAIK for SQL Server 2005, the only other product I have come across is:
http://www.quest.com/toad-for-sql-server/software-downloads.aspx

Not 100% sure if that is for 2005 though.

Other than that, you could try fn_dblog() function directly within SQL e.g.:
http://www.novicksoftware.com/udfOfWeek/Vol1/T-SQL-UDF-Volume-1-Number-27-fn_dblog.htm

Though to be honest, to get a comprehensive, user friendly tool for SQL 2005 isn't going to be cheap so I wouldn't be surprised if ApexSQL is your best bet.
0
 

Author Closing Comment

by:arms145
ID: 31507455
Thanks, TOAD  works great at a reasonable price.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question