Daily we ship our SQL Server backups across the WAN. We need to minimize the size of these backups so it does not take forever.
We don't mind if our backup process takes a bit longer; as it stands we need to move 30gigs of compressed backup across the WAN that takes over 10 hours.
There are 2 options we have to get smaller daily backups.
- Log shipping, which would mean we would have to restructure DR process.
- Strip information out of the db and rebuild on the other side (drop non clustered indexes, pack clustered indexes at 100% - rebuild on the other side)
Both would involve a fair amount of work from our part. We are using SQL Server 2008 pro, all backups are compressed.
Are there any commercial products that can give us similar backup size to option (2)?
Is there a comprehensive script out there that will allow us to accomplish (2)? (handling indexed views, filtered indexes, foreign keys and so on)