Sql Sever 2005 Vendor tools

Hi I need to purchase some Sql software to compress and quickly backup data
files, proactively monitor a whole range of servers in real time and I need
auditing at the log level for ddl events and rollbacks in case of emergencies.


Idera SQL Diagnostic Manager --for monitoring
Aspex ApexSQL Log --for logs
Quest LiteSpeed --for backups

I believe these to be the best products for each task but my problem is they
are all from different vendors. Would you purchase what you thought was the
best or just get everything from one vendor and compromise slighlty on the
product?

thanks for any real world advice on this matter.

Sammy

You might also want to consider looking at HyperBac for backups. Personally
I am not using it in production, even though it compared favorably to
RedGate, but only because we already had an investment in RedGate (both
license costs and automation around it). There are some advantages it has
over others that may be valuable in your case, for example fewer
services/XPs, and an easier transition to native backups when you move to
2008+ (since commands are native).

Basically, you should not just pick the product you think is best because of
your perception, how often you've heard the name, or what some yonker like
me in a newsgroup might say about it... You should actually try them,
because no matter what you read or hear, your experience in your environment
might be completely different.


On 8/26/08 6:07 PM, in article
A162E3CC-0A7E-4B4D-A443-FD57689F964B-at-microsoft.com, "Sammy"
wrote:

> Hi I need to purchase some Sql software to compress and quickly backup data
> files, proactively monitor a whole range of servers in real time and I need
> auditing at the log level for ddl events and rollbacks in case of emergencies.
>
>
> Idera SQL Diagnostic Manager --for monitoring
> Aspex ApexSQL Log --for logs
> Quest LiteSpeed --for backups
>
> I believe these to be the best products for each task but my problem is they
> are all from different vendors. Would you purchase what you thought was the
> best or just get everything from one vendor and compromise slighlty on the
> product?
>
> thanks for any real world advice on this matter.
>
> Sammy
>

Thanks Aaron,

Yes I downloaded Redgate after your previous post and the speeds and
compression are very good and the product is very intuative. I'll also have
a look at HyperBac but Redgate is the best I've tried so far.



"Aaron Bertrand [SQL Server MVP]" wrote:

> You might also want to consider looking at HyperBac for backups. Personally
> I am not using it in production, even though it compared favorably to
> RedGate, but only because we already had an investment in RedGate (both
> license costs and automation around it). There are some advantages it has
> over others that may be valuable in your case, for example fewer
> services/XPs, and an easier transition to native backups when you move to
> 2008+ (since commands are native).
>
> Basically, you should not just pick the product you think is best because of
> your perception, how often you've heard the name, or what some yonker like
> me in a newsgroup might say about it... You should actually try them,
> because no matter what you read or hear, your experience in your environment
> might be completely different.
>
>
> On 8/26/08 6:07 PM, in article
> A162E3CC-0A7E-4B4D-A443-FD57689F964B-at-microsoft.com, "Sammy"
> wrote:
>
> > Hi I need to purchase some Sql software to compress and quickly backup data
> > files, proactively monitor a whole range of servers in real time and I need
> > auditing at the log level for ddl events and rollbacks in case of emergencies.
> >
> >
> > Idera SQL Diagnostic Manager --for monitoring
> > Aspex ApexSQL Log --for logs
> > Quest LiteSpeed --for backups
> >
> > I believe these to be the best products for each task but my problem is they
> > are all from different vendors. Would you purchase what you thought was the
> > best or just get everything from one vendor and compromise slighlty on the
> > product?
> >
> > thanks for any real world advice on this matter.
> >
> > Sammy
> >
>
>

On Aug 26, 6:07*pm, Sammy wrote:
> Hi I need to purchase some Sql software to compress *and quickly backupdata
> files, proactively monitor a whole range of servers in real time and I need
> auditing at the log level for ddl events and rollbacks in case of emergencies.
>
> Idera SQL Diagnostic Manager *--for monitoring
> Aspex ApexSQL Log * * * * * * * *--for logs
> Quest LiteSpeed * * * * * * * * * *--for backups
>
> I believe these to be the best products for each task but my problem is they
> are all from different vendors. *Would you purchase what you thought was the
> best or just get everything from one vendor and compromise slighlty on the
> product?
>
> thanks for any real world advice on this matter.
>
> Sammy

Sammy - depending on what you are looking for on the monitoring
portion you may want to have a look at xSQL Profiler (http://
www.xsqlsoftware.com/Product/xSQL_Profiler.aspx) - it allows you to
define traces and schedule them to run on multiple servers at
predefined times - it automatically collects all the trace data from
the target servers into the central repository where you can query it.
It does not need any agents on the target servers so you can deploy in
minutes. It is simple - no bells and whistles.

I hope this helps.

JC
xSQL Software
http://www.xsqlsoftware.com