Red gate Sql Backup is not giving expected performance
sumit.nitian
Posts: 2
Hi
We have installed SQL backup two days ago and we are not getting the expected results. we have the following configuration on the server
Total Dbs:38
DBs native size:417 GBs ( couple of Db around 100 GB)
total backup size with SQL Backup is 273 GB (34% compression with level 3).in one the Db it is giving compression of only 2% ,we were expecting atleast 50% compression and also the backup time has also increased from 2 hours to 4 hours.
Please help how can we get the expected results...TIA.
We have installed SQL backup two days ago and we are not getting the expected results. we have the following configuration on the server
Total Dbs:38
DBs native size:417 GBs ( couple of Db around 100 GB)
total backup size with SQL Backup is 273 GB (34% compression with level 3).in one the Db it is giving compression of only 2% ,we were expecting atleast 50% compression and also the backup time has also increased from 2 hours to 4 hours.
Please help how can we get the expected results...TIA.
Comments
Thank you for your post into the forum.
The amount of compression will depend on the type of data in your databases. If for example your databases contain a lot of image or binary data the amount of compression achievable will be minimal.
We do have a Compression Analyzer which you can use to see the expected amount of compression for each of the different levels, have you tried this? It is available on Step 4 of the Backup wizard or in the SQL Backup GUI installation directory.
With regards to the backup time increasing, have you tried multiple threads in your job?
Thanks,
Redgate Foundry