Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Litespeed Vs Native Backup? Expand / Collapse
Author
Message
Posted Friday, January 7, 2011 7:43 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
Thanks Everyone here. I shall prefer litespeed in my env.

Litespeed Link really helped.
Post #1044831
Posted Saturday, January 8, 2011 2:27 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:16 AM
Points: 7,163, Visits: 15,084
Native compression is good but if you enable TDE compression is negated. Litespeed or SQLBackup will compress and encrypt your backups

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1044922
Posted Monday, February 23, 2015 11:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 20, 2015 1:48 PM
Points: 37, Visits: 36
Anybody have performance details based on newer version of SQL Server, I heard that SQL 2012 and 2014 has better compression now that is comporable to LiteSpeed.

I suppose could take a backup myself and see the compression details. Just wanted to find out before I do this research myself.

Thanks,
N
Post #1662676
Posted Wednesday, February 25, 2015 8:00 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 23, 2015 3:52 AM
Points: 36, Visits: 65
Even with 2008R2 we seemed to get better performance natively than with LiteSpeed - LiteSpeed really saved us with SQL 2000 and 2005, but the day we got 2008R2 - boy that was fast!

Stats for a 120GB database, full backup:-

SQL 2000 native - 90 minutes
LiteSpeed - 30 minutes
2008R2 native - 10 minutes
Post #1663388
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse