The biggest benefit that I see with the new backup compression in SQL Server 2008 is that it improves the speed of the restore. The thing that is far more important that a database backup is the actual restore process, and with a compressed backup, this can speed up the restore time by as much as 40% which can make a huge difference with larger databases.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!