SQL Server Database Administrators often run out of space due to huge backup files that have been retained on the disk. This article illustrates how to take full and transaction log backups and compress the backup files using the reasonably priced WinZip. http://www.databasejournal.com/features/mssql/article.php/3556461 http://www.databasejournal.com/features/mssql/article.php/3558641 ---------------------------------------- Cast your vote http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
I always to have such compressed utilities on a SQL server, they tend to crunch the resources when the time comes to perform well by SQL. Always better to use WINZIP from other file server than on SQL server alone. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.