February 4, 2011 at 6:42 am
I am curious if anyone has any experience with using compression during the log shipping process. I know that it can be configured, but does anyone have opinions or practical experience on the benefits / impact of doing this?
Appreciate any responses that come my way.
February 4, 2011 at 2:43 pm
I use backup compression for log shipping between 2 SQL 2008R2 servers. I don't see any downside to it.
Faster/smaller backups, copies and restores. I suppose there is slight CPU overhead to do the compression but I haven't noticed it at all.
March 5, 2011 at 11:15 am
JeremyE (2/4/2011)
I use backup compression for log shipping between 2 SQL 2008R2 servers. I don't see any downside to it.Faster/smaller backups, copies and restores. I suppose there is slight CPU overhead to do the compression but I haven't noticed it at all.
Agreed. CPU isnt normally the bottle neck on modern servers. Disk IO however is and by compressing the backups you are reducing the amount of disk contention through smaller files. Win-Win.
(similar principle applies to compressed tables)
March 7, 2011 at 4:18 am
Just curious, is compression recommended in log shipping if we are using third party tools like SQL lite etc for backup/restore.
M&M
March 8, 2011 at 4:35 am
Since SQL 2008 has come up with inbuilt backup comprassion then why should we look for 3rd party tool.
Also, i believe that 3rd party backup comprassion will not be practically possible in SQL Logshipping ( may be members can contribute to this more).
March 8, 2011 at 5:15 am
Chetan, I was not referring to SQL Server 2008 alone. As backup compression is a new feature introduced in SQL Server 2008, I thought we could use third party tools in earlier versions.
M&M
March 8, 2011 at 5:47 am
to have backup files compressed in log shipping, i think you need to install that particular 3rd party tool on both the servers ( primary & secondary - on Primary for compressing the file and on secondary to uncompress the file).
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply