ss-457805 (8/13/2010)
log ship wizard in 2K8R2 Std not showing compression option,but compression column is present in log_shipping_primary_databases. The option should still show in the wizard rite? Am i missing something?Did any one else had this issue?
Backup compression is available in SQL Server 2008 R2 Std.
Try the following against your primary database and check the value of the backup_compression column
exec sys.sp_help_log_shipping_primary_database @database = 'yourdb'
Use the following to enable compression
exec sys.sp_change_log_shipping_primary_database @database = 'yourdb',
@backup_compression = 1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉