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 @ 10:56 AM
Points: 7,033, Visits: 14,859
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: Wednesday, February 25, 2015 4:22 PM
Points: 33, Visits: 22
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


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 23, Visits: 32
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