By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,413 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,413 IT Pros & Developers. It's quick & easy.

Log Explorer vs. ApexSQL Log vs. SQL Log-Rescue

P: n/a
Opinions?

I've installed all three to try'em out and they all seem to be working
so far, more or less.

Log Explorer has given me a couple of errors but I started over and
continued OK.

ApexSQL Log squawked about "redo for delete cannot be generated for
tables lacking clustered index". Huh? What the...? We have lots of
tables without a clustered index.

I read some reports in Red-Gate's technical support forum about their
product actually bringing down SQL Server. That did not inspire
confidence.

All three install some server-side components like extended stored
proc's which I'm not crazy about and I think all three are server or
instance licensed (does anyone actually purchase more than one license
when it seems like you can easily move any tran log to be analyzed to
the server the product is installed on?). I don't think I'd want to
install any of them on a Production server, at least one that I'm
responsible for!
Thanks,

Martin

Jun 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Martin (mv****@olgc.ca) writes:
ApexSQL Log squawked about "redo for delete cannot be generated for
tables lacking clustered index". Huh? What the...? We have lots of
tables without a clustered index.


Probably the people at ApexSQL are like me: they think that every table
should have a clustered index.

If nothing else, fragmentation is easier to keep in check, if you have
a clustered index.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.