InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 14:49:56 GMT20http://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspxNative compression is good but if you enable TDE compression is negated. Litespeed or SQLBackup will compress [u]and[/u] encrypt your backupsSat, 08 Jan 2011 14:27:41 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspxThanks Everyone here. I shall prefer litespeed in my env.[url=http://mssqlcorruptiontackle.blogspot.com/2011/01/comparison-between-litespeed-backup-and.html]Litespeed Link[/url] really helped.Fri, 07 Jan 2011 19:43:27 GMTluckysql.kindahttp://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspx[quote][b]Elliott Whitlow (1/7/2011)[/b][hr][quote]As far a sproc restore, I'm taking the position that if you have to go to the backup to get source code, that code control is likely an issue in your organization. The database is a recipient of the code not a storage location.. Sorry..CEWII[/quote]No reason to be sorry. I was merely highlighting the feature set and differences between Litepseed backups and compressed native SQL backups.If you don't need object level restore, variable compression, or want to pay $1500/server then compressed native SQL backups will work just as well.Fri, 07 Jan 2011 16:39:04 GMTJeremyEhttp://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspx[quote][b]JeremyE (1/7/2011)[/b][hr]A big win for Litespeed is the ability to do object level restores. Restoring a single table or proc is much easier than restoring an entire TB sized database and extracting the single table.[/quote]As far as single table, I'll give you that.. Out hosts Red-Gate has a tool that lets you mount the backup like a database and access it directly, very cool..As far a sproc restore, I'm taking the position that if you have to go to the backup to get source code, that code control is likely an issue in your organization. The database is a recipient of the code not a storage location.. Sorry..CEWIIFri, 07 Jan 2011 16:30:23 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspxA big win for Litespeed is the ability to do object level restores. Restoring a single table or proc is much easier than restoring an entire TB sized database and extracting the single table.Fri, 07 Jan 2011 16:20:22 GMTJeremyEhttp://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspxInteresting reading.. But at ~$1500/server I don't think I could stomache it for any but the most obscenely large database servers. The smaller backup files than native with compression is nice but only a partial justification for purchase. For SQL 2005 I would be a bit more open, but the price is still a deterent..CEWIIFri, 07 Jan 2011 15:31:57 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspxI prefer LiteSpeed over SQL native compression. I have been using this for couple of my projects. LiteSpeed provides various compressions levels to use. I went with default which is 1. It saves little over 80% in terms of disk space. LiteSpeed also has integrated Log Shipping in case if you need and also lot of other features. Good Luck.Thanks,SatishFri, 07 Jan 2011 12:50:50 GMTSatish-219904http://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspxThanks MichaeljassonFri, 07 Jan 2011 12:01:20 GMTanuraganu.tiwarihttp://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspxThanks for the post, Michael.-luckyThu, 06 Jan 2011 22:49:34 GMTluckysql.kindahttp://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspx[url=http://mssqlcorruptiontackle.blogspot.com/2011/01/comparison-between-litespeed-backup-and.html]Comparison between Litespeed Backup and Native Backup Compression[/url] -MichaelThu, 06 Jan 2011 21:24:27 GMTMichaelJassonhttp://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspxboth have the different compression algorithm. And I personally prefer litespeed.Thu, 06 Jan 2011 20:55:03 GMTcrazy4sqlhttp://www.sqlservercentral.com/Forums/Topic1044114-391-1.aspxWe have upto 1TB DBs in our environment and total size of all the backups reach upto 48TB. Any heads up whether Litespeed is still better than Native with compression?-LuckyThu, 06 Jan 2011 20:51:39 GMTluckysql.kinda