Solved

SQL Server 2005 Transaction Log Viewer/Explorer

Posted on 2008-10-18
3
6,002 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

Title # Comments Views Activity
Sql Query join multiple table and distinct records 7 31
Caste datetime 2 64
date diff with Fiscal Calendar 4 55
convert null in sql server 12 47
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…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

829 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