Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2007-08-20 : 10:24:44
|
| Guys,I recently compressed the folders where we store backups, as suggested here: http://www.databasejournal.com/features/mssql/article.php/3064361. Once I did it, however, the backup time increased from 1 hour to 5 hours.Can anyone tell me whether this is normal and if there is a way to avoid this?Thanks a lot! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-20 : 10:26:52
|
Yes, it will be slower because the CPU has to compress a lot of data!Let the backup application compress the data, not the Windows Server.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-08-20 : 11:13:35
|
| What backup application?Are you referring to some 3rd party tool? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-20 : 23:15:59
|
| Yes, like Quest's litespeed or Idera's backup tool. |
|
|
|
|
|
|
Compression leads to slower backup - can this be?