- Use a third party backup tool that allows you to do compression of the backup files such as:
- 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
Back up tables from a SQL Server database to a file with these commands.continue reading
Find out how to restore data from a corrupt database.continue reading
Avoid restoring your SQL Server database to solve the SQL Server error message "server out of memory." The problem could be the memory settings.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.