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: Today @ 7:36 AM
Points: 7,478, Visits: 15,490
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: Tuesday, July 28, 2015 4:21 PM
Points: 37, Visits: 57
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: Tuesday, June 2, 2015 3:58 AM
Points: 42, Visits: 85
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