Is there any possibility to compress the database backup's to save the storage space on backup media ,if so upto how much extent we can compress?.Presently im working with SQl-2K5.Thanks in advance.
Or... schedule a batch file after the backups already done...
@ECHO Compressing BAK files! for %%a in (*.bak) DO ( "C:\Program Files\7-Zip\7z.exe" a -y %%a.7z %%a if errorlevel 1 goto error del %%a :Error move *.7z .\Compressed )
SQL Server 2008 has this ability natively, but in 2005 you will need a 3rd party tool. I personally am quite partial to Red Gate SQL Backup , but there are also competing products. [Edit, forgot the answer the percent question] As always the answer to how much it can be compressed is, it depends on things such as the data structure and the compression setting you use, but to give you a rough idea, I routinely got around 80% compression with SQL Backup.
You could use a non-integrated solution by compressing it after the fact with something like 7-Zip or WinZip though this is likely to give you poor performance compared to the integrated solutions like Red Gate SQL Backup.
1 Person is following this question.