JohnSQLServerCentral (5/6/2010)
Can anyone confirm whether Backup Compression is included in the new SQL 2008 Standard R2, or is it still just for Enterprise? This really should be offered Standard.
The Microsoft literature says that Standard edition now gets backup compression. From this link: http://www.microsoft.com/sqlserver/2008/en/us/R2-editions.aspx
"The following capabilities are new to Standard:
Backup Compression to reduce data backups by up to 60% and help reduce time spent on backups *
Can be managed instance for Application and Multi-Server Management capabilities
High-scale complex event processing with SQL Server StreamInsight™"