What are the challenges you face when working across database platforms? Take the survey
Options

Red gate Sql Backup is not giving expected performance

sumit.nitiansumit.nitian Posts: 2
edited November 24, 2008 7:24AM in SQL Backup Previous Versions
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.

Comments

  • Options
    Hi Simut,

    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,
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.