Is there not a way to backup a database and compress the .mdf while it is backing up? Do I have to invest in a third party tool like Red-Gate's SQL Back or Idera's SQLSafe? If I use zip to compress...there is really no performance or storage saving. Is there anything on the market more efficient than winzip that will compress the .bak during the backup process?
3rt party tool like Reg Gate SQL Backup. I used a lot and no problems. Luis Martin Moderator SQL-Server-Performance.com All in Love is Fair Stevie Wonder All postings are provided “AS IS†with no warranties for accuracy.
http://www.sql-server-performance.com/sqlzip_spotlight.asp Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.
if you do not want to pay for a 3rd party product, you write your own SQL backup compression utility search the MS site for VDI, there is a sample program on how to use VDI for backup then go to Source Forge to find some good open source compression utilities figure this would take you about 1 week for a basic tool, you are on your own for support or you could pay for the 3rd party product with support
How big is the database backup file you're talking here? Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.
Actually...I am doing backups from a couple dozen servers...all .bak's ranging in size from 5-28GB. On average, I would say 15GB in size. I was looking at the sqlzip article. That solution looks very feasible for me at this time.
Also have look around Spotlight on other tools that might help you. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.
