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 |
|
antony_dba
Starting Member
26 Posts |
 Posted - 2010-11-29 : 02:11:44
|
| Dear all, I like to know the information about how to compress the backupif you know suggest the query.kris |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-29 : 03:47:27
|
| SQL 2005 does not have built in backup compression. You'll have to buy a 3rd party backup tool that offers compressed backups. Litespeed and RedGate's SQLBackup are two examples.--Gail ShawSQL Server MVP |
 |
|
|
antony_dba
Starting Member
26 Posts |
Posted - 2010-11-29 : 04:11:30
|
| ok but In microsoft sql server 2008 has compress backup option .From right click database then database setting there is a checkbox for compress backup it's available for sql server 2008 but not for 2005suggest the comments...kris |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-11-29 : 04:59:28
|
| Yes, it's available for 2008 (enterprise edition only) but not 2005. If you want it in 2005, you'll need to buy a 3rd party backup tool that offers compressed backups.--Gail ShawSQL Server MVP |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-29 : 05:02:33
|
| >> suggest the comments...?????Do you have v2008 or v2005?If v2005 do you expect things in v2008 to be available? If so you are going to be very disappointed.Did you read GilaMonster's posts?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
COMPRESSED BACKUP