Red-Gate vs LiteSpeed

[DrSql]

Is anyone have any thoughts or experinces working on both Red-Gate & LiteSpeed. The Pro's and Con's, Price, Licensing and Customer Support.
Any feedbacks are gretly appreciated.
Thanks


Dr.Sql
Good Luck.

 

[ptheriault]

I've only worked with LiteSpeed. I can tell you it is an excellent product with even better support. I've backed up 800 GB databases. the ending bak file was @95 GB. This makes it much easier to move database files around for backup and restores. I have also used LiteSpeed for Logshipping of that same 800 GB database. The only con with products like LS is that you must have the same version on every SQL Server that you will need to restore the bak file on. They also charge by the CPU. but the do give 50% off for non prod server. Also if you get the enterprise version you can do table level restores.
Oh I almost forgot. The syntax for litespeed is very similar to native TSQL. Here is an example.

--restore to different db
Exec master.dbo.xp_restore_database 
@database = 'test',
@filename = 'd:\programs\mssql\backup\litespeed_hr8dev.bak',
@with = 'MOVE "HRPRD_Data" TO "d:\programs\mssql\data\test_DATA.mdf"',
@with = 'MOVE "HRPRD_Log" TO "d:\programs\mssql\data\test_Log.ldf"',
@with  = 'NORECOVERY',
@with = 'REPLACE'


Restore db.
Exec master.dbo.xp_restore_database @database = 'lite_test',
@filename = 'd:\programs\mssql\backup\litespeed_hr8dev.bak'

--backup
EXEC master.dbo.xp_backup_database @database = 'HR8DEV',
@filename = 'd:\programs\mssql\backup\litespeed_hr8dev.bal',
@init = 1

We don't use LS speed on all our servers. for the most part the native SQL backup utilities are more than enough. But we for databases over 100 GB we use LS. We find that the money saved n space with backup compression is significant.

- Paul

- If at first you don't succeed, find out if the loser gets anything.