Any free sql backup compression utility ?

If not free, one with the lowest price is recommended. I heard of Litespeed.
Are there any lower priced than that ? I just have one server that I would
like to backup.Romeo wrote:
> If not free, one with the lowest price is recommended. I heard of
> Litespeed. Are there any lower priced than that ? I just have one
> server that I would like to backup.
http://www.idera.com has a free version available.
Also, check out http://www.codeproject.com/KB/cs/VdiDotNet.aspx - for a
way to build your own.|||You will get "free" backup compression in SQL Server 2008 :)
--
Rubén Garrigós
Solid Quality Mentors
"Romeo" <romeo@.juliet.com> wrote in message
news:epbTt3VZIHA.984@.TK2MSFTNGP06.phx.gbl...
> If not free, one with the lowest price is recommended. I heard of
> Litespeed. Are there any lower priced than that ? I just have one server
> that I would like to backup.|||LiteSpeed used to have a Free version for smaller systems but I haven't
checked lately. You may also want to look at www.red-gate.com for their
backup compression utility as well.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Romeo" <romeo@.juliet.com> wrote in message
news:epbTt3VZIHA.984@.TK2MSFTNGP06.phx.gbl...
> If not free, one with the lowest price is recommended. I heard of
> Litespeed. Are there any lower priced than that ? I just have one server
> that I would like to backup.|||Hi,
I perform backup by maintenance plan tasks and think about add additional
task to compress backups and delete original backups.
Do you know some script base resolution (winzip, winrar, 7zip...)?
--
Regards,
anxcomp|||From what I understand there is a command line version of winzip. But that
does not give you the same thing as using one of the tools from Red-gate or
Quest. They compress the backup as it is being read and when written it is
already compress. You would have to do it in two steps and it would require
much more CPU & Disk I/O than with Red-Gate. Not to mention you now have to
have extra disk space to store the initial backup before you compress it.
The same is true for restores. It makes the process much longer and more
difficult than it needs to be.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"anxcomp" <anxcomp@.discussions.microsoft.com> wrote in message
news:F6756C86-51F1-4344-85ED-A20ADA7E32F8@.microsoft.com...
> Hi,
> I perform backup by maintenance plan tasks and think about add additional
> task to compress backups and delete original backups.
> Do you know some script base resolution (winzip, winrar, 7zip...)?
> --
> Regards,
> anxcomp|||Hello,
This is good for me, I don't want live compression and decompression. My
databases are on simple mode I perform only full nightly backup.
Do you use some scripts (vbs, sql with xp_cmdshell or something...) to
perform this task?
Thank you inadvice
--
Regards,
anxcomp|||What does the fact this is in simple mode have to do with this? In any case
have a look here:
http://www.winzip.com/prodpagecl.htm
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"anxcomp" <anxcomp@.discussions.microsoft.com> wrote in message
news:6195075F-3BB9-4D62-8088-A107309DC75E@.microsoft.com...
> Hello,
> This is good for me, I don't want live compression and decompression. My
> databases are on simple mode I perform only full nightly backup.
> Do you use some scripts (vbs, sql with xp_cmdshell or something...) to
> perform this task?
> Thank you inadvice
> --
> Regards,
> anxcomp