April 29, 2009 at 3:15 am
HI friends,
I am having Database Backup files. I am having a doubt that How can we ZIP the files through SQL command Queries.
If not such flexibility , tell me how to reduce the Backup files to a maximum level
Thank You all,
Venu Gopal.K
Software Engineer
INDIA
April 29, 2009 at 3:54 am
You can compress your backupfiles by calling a compression tool through xp_cmdshell, but personally I would advise against it for two reasons. First of all you need even more diskspace while the compression tool is working and second in order to restore them you must first unzip your files, which costs valuable time.
I would advise to have a look at the various backup uitilities which support compression during the backup process like SQLBackup (Red-Gate), SQLLightspeed (QUest-Software) or SQLZip. There are probably some more, but I can't remember them.
You might also have a look at this thread from some time ago:
http://qa.sqlservercentral.com/Forums/Topic16761-24-1.aspx#bm81344
[font="Verdana"]Markus Bohse[/font]
April 29, 2009 at 4:12 am
Hi
Use "sqllitespeed" if you want to compress backup its much faster than taking backup and zipping.
Tanx 😀
April 29, 2009 at 4:18 am
Hi , tahnk u for u r suggestion , but i donno what a Sqllitespeed means, can u tell me about that thing elaborately
thank u
Venu Gopal.K
Software Engineer
INDIA
April 29, 2009 at 4:23 am
Search google for 'litespeed'.. its a third party software
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply