This post is more than 5 years old
1 Rookie
•
47 Posts
0
1326
June 30th, 2015 00:00
While configuring a SQL backup in networker does SQL server compression is recommended??
Hi,
When we configure a SQL backup is it recommended to enable SQL server compression for that? And why it is Recommended/not Recommended??
No Events found!
CarlosRojas
1.7K Posts
0
June 30th, 2015 00:00
Hi sokundu
It all depends.
Compression should improve the performance, as the amount of data sent over the network is smaller (being compressed), however, if you are using Data Domain as backup device, then do NOT pre-compress the data, as that will have big impact on the deduplication ratio, so or Data Domain backups definitely pre-compression should not be enabled.
So by default it is not recommended to enable the compression of SQL, but as said at the beginning, it all depends on your environment.
Please let me know if you need any further information.
Thank you,
Carlos
sokundu
1 Rookie
•
47 Posts
0
June 30th, 2015 00:00
Thanks Carlos,
Yes we are using Datadomain as a backup device.So we will not enable compression from now.
crazyrov
4 Operator
•
1.3K Posts
0
June 30th, 2015 01:00
@sokundu,
Using compression at the SQL end during a backup all depends on your environment. If you think that the additional overhead of compressing the data before backing it up does not affect the over all performance of your SQL server then you can go ahead but again this is at the SQL end so NetWorker would not affect the performance much.