My workplace (SSW) is looking at standardizing our MSSQL backup procedures by having the same maintenance plan on each SQL server in the origination. I was asked to make this plan put backups to a local hard drive on each SQL server, which I disagreed with. My boss, Adam Cogan (Microsoft Regional Director) asked for Greg Low’s (Microsoft Regional Director, SQL Server MVP and owner of the SQL Down Under podcast) opinion on the matter. He advised that he also runs local backups on all of his MSSQL Servers, and then later copies them to a centralized network location.
The main points I was arguing that it is better to backup directly to a network share were:
Further to that, the servers here at SSW are backed up using Microsoft System Center Data Protection Manager 2010 Beta. DPM synchronizes the data from our SQL server every 2 hours, this removes the need to do transaction log backups. This aligns with the companies Recovery Point Objective (RPO) – which describes the acceptable amount of data loss measured in time.
For these reasons, I choose to backup directly to a network location instead of locally as recommended.