- Use a third party backup tool that allows you to do compression of the backup files such as:
Step 2 of 2:
- Write your full backup to multiple files, so each of these can be sent individually. These can also be compressed using WinZip or some other compression software.
- Use a third party fail over solution that keeps the two boxes in synch. These tools also have compression capabilities to allow you to send data over a WAN. Some of these tools include:
Dig Deeper on SQL Server Backup and Recovery
Related Q&A from Greg Robidoux
Find out how to restore data from a corrupt database.continue reading
Back up tables from a SQL Server database to a file with these commands.continue reading
Restore backups in SQL Server 2000 and SQL Server 2005 with this command.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.