- 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
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
Synchronize databases on separate servers without using SANs. Learn options for server failover in SQL Server including log shipping, database ...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.