| Author |
Topic |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2008-01-21 : 10:06:31
|
| Has anyone used SQL Litespeed .We have 1 TB database and moving to different location so we want it to be done fast. How is compression ratio of backup files and how does it work with SQL server 2005? Is it easy to install in Production environment. How much does it cost?Please experts, Throw some light. |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-01-21 : 11:05:32
|
| We have used SQL Litespeed with SQL 2005 64-bit. It works well, and it restores well, too. Our databases are largely text/image data, so we only get about 50% compression. One thing to note is when the backup begins, the CPU will spike up. So, if you are already using a lot of CPU, this may not be the tool for you. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-21 : 11:43:09
|
| Used it in a few places i've worked and never had any problems with it. Seems to work quickly and restores are good. Installation is easy as well.As mcrowley said, the only think is a spike in CPU when backing up.EDIT: Pricing (AFAIK) was per processor, but that was when it was owned by Imceda, take a look at http://www.quest.com/litespeed-for-sql-server/ |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-21 : 12:29:00
|
| litespeed is a good product. we have used it for years and have come to depend upon it. I would contact quest for a quote.other similar products are SQL Backup from red-gate software and idera SQL Safe. You might want to take a look at all 3 products.-ec |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-21 : 12:44:22
|
| Thanks a lot for everyone.My database is almost 1TB and i want to compress it 80-90 % so i can move easily to other location.Which tool will be best for this scenerio? Please advise. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-01-21 : 12:49:05
|
| What should i do after i move the compressed backup files to destination server? Do i have to uncompress the backup files or can i restore directly with that files? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-01-21 : 13:29:55
|
quote:
Originally posted by sodeep
What should i do after i move the compressed backup files to destination server? Do i have to uncompress the backup files or can i restore directly with that files?
you restore the compressed file directly. All three products I mentioned use custom procedures that replace the built-in sql backup/restore commands to accomplish this.-ec |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 15:41:45
|
| Idera's sqlsafe can convert compressed backup file to regular backup file. Litespeed has per server license.Both sqlsafe and litespeed can specify number of cpu threads for backup. |
|
|
|
JakeChilds
Starting Member
1 Post |
Posted - 2008-02-22 : 09:03:23
|
| We've been using this litespeed for some years with a great success. It really compresses sql databases to 90-95 percent and even more in some cases. In your case you will be able write backups simultaneously to two different destinations. In addtion, litespeed uses special technology for decreasing end-user impact during the backup process, so your users can work as usual.Regards, Jake |
|
|
|
clay_lenhart
Starting Member
1 Post |
Posted - 2008-09-01 : 17:23:06
|
| Another option is the open source project, SQL Server Compressed Backup [url]http://mssqlcompressed.sourceforge.net/[/url] which has the option of using bzip2 compression, which will give you a much smaller file size at the expense of using much more CPU to compress the data. |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2008-09-02 : 15:59:30
|
| SQL LiteSpeed is an awesome tool,Our Db is 1.2TB,It compresses to 250GB.It took 6hrs for backup.Using this you can split the backup file into number of pieces,so that its easy to copy over the network. |
|
|
|
|
Has Anybody used SQL Litespeed