This is my first post and I wish to share my experiences with you,which
can be helped in your day to day work.
When I was configuring Log shipping in SQL Server 2008 R2
Standard edition, I noticed that log files were too large to copy via VPN links. So I had to try to
compress Log file from Log shipping option, but Log compression option was not
available.
But in Database backup option, Backup compression option is
available.
So !!! SQL engine can compress the backup,if it is not available in Log shipping option, How do I compress my log shipping backups?
Solution is,
In msdb, you can
find table call [dbo].[log_shipping_primary_databases]
where all the information about log shipping primary databases save and Table has a Column call backup_compression. It shows the backup compression
status.
Value and meaning of Column backup_compression
0
Disable
1
Enable
2 Server default
Once you change the value in to 1 and you may able to compress the backup
