November 8, 2011 at 3:02 pm
We are running 50 or so servers of of 2000, 2005, 2008 R2. We want to use a back up software package so we can get compression to get smaller backups. Most of our servers are virtual. We dump all of our backups to a Network Area Storage system. We want to reduce our footprint. Just want to know what everyone thinks that is best but also reasonably priced. Used to use Lightspeed a few years ago at a different employer but haven't seen it in about 3-4 years.
Scott
November 8, 2011 at 3:15 pm
We used Redgate until recently but we are starting to use SQL Server backup Compression since SQL 2008 R2. In our experience this is 5 times faster than Redgate.
Redgate does offer better compression than SQL Server but I would take speed over space since storage is getting cheaper every day.
November 9, 2011 at 8:34 am
I have used Redgate & Idera and have been happy with both.
One problem I see with asking in a forum is that we may have experience with a product, but the features may have changed recently, so you might not get the most up-to-date answer. In addition to reading replies, get the latest demo version from the company and compare features based on company provided information.
November 9, 2011 at 8:36 am
with 2008R2 you get compression anyway with the native backup so stick with that.
For earlier versions of SQL I like Hyperbac (now a redgate tool) as you dont have to change your backup scripts at all or use some annoying gui, it just intercepts backup and restore commands and performs the compression on the fly.
---------------------------------------------------------------------
November 9, 2011 at 9:37 am
I still need it for the older flavors.
November 21, 2011 at 7:16 am
Hi,
If you want additional compression with SQL Server's built-in native backup support, you can use a 3rd party application. Because, it will dump the backup data with compression locally and then further compress and send the database data to backup server/destination location. So, you will get additional compression with that 3rd party application.
Also, 3rd party application will support and manage the backup type hierarchy (full, differential, bulk log) and checks for integrity of the backup.
--
Aravind,
Vembu Technologies.
November 21, 2011 at 1:53 pm
george sibbald (11/9/2011)
with 2008R2 you get compression anyway with the native backup so stick with that.For earlier versions of SQL I like Hyperbac (now a redgate tool) as you dont have to change your backup scripts at all or use some annoying gui, it just intercepts backup and restore commands and performs the compression on the fly.
Yes I also use and recommend this approach. It allows you to standardize your backup scripts using native SQL commands across SQL servers regardless of the version. No GUI's or XP's or command line to mess with.
November 21, 2011 at 2:25 pm
good to know Ed. Are you on a post redgate version 5 and above release of Hyperbac? How do you find the memory footprint?
---------------------------------------------------------------------
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply