sql server 2008 is having a advantage of database backup compress. which algorithm is used to compress the backup. question seems to funny , but i am planning to made some R&D on developing a custom backup
OK i agree with that ,but what generally happens in a zip algorithm is it just searches the file with a repeated word and it replaces it with a asci code. when unzip it will replace the letter with the repeated word example tody went to **fruit** market , in the **fruit** market he met his friend who was selling **fruit**s. he bought some **fruit**s also ate some **fruit**s there in the above paragraph we can see word fruit is repeated 5 times. now fruit is replaced with ^ symbol now you see the paragraph how it is tody went to ^ market, in the ^ market he met his friend who was selling ^ he bought some ^ also ate some ^ there ((((key is ^=fruit))) this is how zip is done. but in sql server 2008 database. we have very less probability of word repetition . then how does it compress the backup
Backup compression and table compression are done in completely different ways. Both are only available only in Enterprise Edition. Ramesh's explanation is nearest to table compression. There are third party tools that will do both of these more efficiently, and cheaply.