Lite Speed Bakup-Restore Duration

Question

Lite Speed Bakup-Restore Duration

Tara-1044200

SSCoach

Points: 15951
More actions
May 6, 2009 at 4:33 pm

#221006

So far I was assuming that the more i compress the backup file it would take more time to restore with litespeed but that isnt, i did some test and found that the more i compress the backup file restore would be more faster but ofcourse baking up would be opposite, the more you compress it takes more time to backup.
I did test by changing the compression level of backup file from 1-10, the backup file with compression level 10 was much faster but the backup file with level 1 was much slower.
could some one explain me the logic behind.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

The compression is being done on the fly, as it is being written to disk. The compression occurs in memory faster than the writes to disk, this results in faster backups, as less is being written to disk.

I use HyperBac, and my backup/restore times are faster than normal backup/restores.

Tara-1044200 SSCoach Points: 15951 More actions · Answer 2

I think you didnt understand my point.

Backups are taking longer with greater compression value and restores are taking smaller time.

Swayambhu narayan Samamtroy SSC Veteran Points: 233 More actions · Answer 3

When you are restoring, SQL Server only needs to read less or compressed amount of data rather than whole database size (reduced Disk IO Reads) and this can considerably less recovery time. 🙂

warm regards

Swayambhu

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 4

The more compression you use the more you penalize the backup process in terms of processing -the more compression the more complex the algorithm.

Restore would benefit of reading a small dump file; uncompress process is less complicated, it doesn't have to figure it out how to better compress the data, just uncompress it.

Hope this helps.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.