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 |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2005-03-11 : 15:19:17
|
| Hello Guys,When we set up back ups, full or differentail, does the server compress anything ? I'll do a test, but I want to confirm...Thanks!Igor. |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-11 : 15:29:19
|
| The SQL server doesn't compress, but it will remove database freespace so you're backup file may be smaller. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-11 : 16:17:32
|
| If you want the backups compressed while they are being created, you can use SQL Litespeed, third party tool. We use this on our servers that have very large databases, 100GB or so.Tara |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-11 : 16:24:24
|
quote:
Originally posted by tduggan
If you want the backups compressed while they are being created, you can use SQL Litespeed, third party tool. We use this on our servers that have very large databases, 100GB or so.Tara
Tara,I checked this out for myself and it seems like a 'pay for itself' deal. Have you ever had to restore a DB that was compressed with this utility? Any issues? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-11 : 16:34:50
|
| Yes I have. And the time that it takes to restore it is greater than what it would take to restore a SQL Server backup file. The file size of the compressed file for us is around 10-25% of the SQL Server backup file. The time it takes to back them up is much much faster also. But the restore time takes considerably longer. So you have to weigh your options here.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-13 : 13:24:41
|
| Sometimes the restores don't take considerably longer. We've actually found the restore times comparable on all our databases. The only exception is where you have a lot of images or binaries in the database. They don't compress well with any of the compression utilities out there. They are slow to backup and restore. Out of curiousity, what version of Litespeed are you on now Tara?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2005-03-14 : 10:27:11
|
| K, I got my question answered, and once again Tara, I'll try this compression tool.Thanks!Igor. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-14 : 13:10:14
|
| We've got 3.0.122.0 installed on two servers.Tara |
|
|
|
|
|
|
|
|
.bak X .mdf