Home Forums SQL Server 2008 SQL Server 2008 Administration Large system coming, looking for advice of how to maintain, over 2TB. RE: Large system coming, looking for advice of how to maintain, over 2TB.

  • January 15, 2013 at 9:08 am

    #1577385

    Markus (1/15/2013)

    Interesting thoughts, thanks.

    Has anyone done any comparision to the SQL2008R2 backups with compression as far as time taken to run and size of backup and compared it to, say LiteSpeed? I would be curious to know how they compare for a VLDB. I dont have anything yet over 1TB or I'd try and compare.

    I found SQL Backups with native compression to be faster and slightly smaller than LiteSpeed backups.

    I also found restoring LiteSpeed transaction logs backups to be much slower. I had a situation where I needed to restore 14 days of tran log backups (made every 15 minutes, 24x7) and it took a very long time, maybe a day. I think there is a lot of overhead to activating the extended stored procedure that LiteSpeed uses for the tran log restore, and that was most of the runtime.

    That was about 2 years ago, so I can't say if LiteSpeed has improved that by now in a later version.

    Can't speak for any other third party products.