As a production SQL DBA contracting for many clients I have found 3rd party compression tools totally invaluable. SQL 2008 compression is fine, but many of my clients aren't even using that version, all their critical systems are SQL2K/2K5 and space has become so bad the storage guys are now stopping any local sql backups! :w00t: And then when an IT director says we can't afford a SQL upgrade, but still demands something to be done about "all those damn databases" then it pays to be aware of what is out there.
On a personal level I like using Quest Litespeed, however I have used whatever the client has in place, such as Idera's SQL Safe backup or Red Gat's Storage Compress, but there are others. What is find it whatever the make and model it is how you use it. The more I have played with all the aforementioned products the more it has helped me on a day-to-day basis, they all have some really cool features.
A few years ago one IT director even asked me if the email was still working as all the "SQL Server: Disk Space Alert" emails had stopped firing after utilising a SQL compression tool enterprise wide. 🙂
[font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]