I have moved the location of sql server backups\restores to a file server on the network at an offsite data center. Unfortunately now my backups/restores for the local reporting server is causing overages to the average bandwidth we pay for from the data center provider per month. Is there a way in sql server to limit bandwidth used for restores/backups?
For clarification, the offsite Data Center is the Production environment for the DB's and I am restoring db's to a local db environment for internal reporting. DB backups are also being copied to an alternate location for D/R purposes. The new part in the equation is the restores across the network for internal reporting. That's what pushed me over my bandwidth limit.