none
Excluding a SQL File Group from DPM Backup RRS feed

  • Question

  • I have numerous SQL 2012 databases that are being backed up by DPM 2012.  However, in each of these databases there is a specific file group that contains a large amount of non-critical (easily recreateable) data that is changes often and causes our backup size to grow exponentially.  I don't want the data in this file group backed up.

    I want to find out how I can (either through DPM or a setting in SQL Server) instruct DPM to exclude a specific file group from the backup.  I want to do this using the native SQL VSS backup and I like (and really need) the auto-protect feature of DPM to backup new databases, so individually selecting individual files for the backup isn't really an option.  Any help or guidance is greatly appreciated.  

    Tuesday, July 30, 2013 8:43 PM

All replies

  • Anybody monitoring this?  Any help is greatly appreciated.
    Tuesday, August 13, 2013 2:40 PM
  • I guess that the only way to automatize this would be to let the auto-protection on and run a periodic powershell script that removes the unwanted databases from the protection group.

    not clean, sure, but...

    Thursday, November 28, 2013 12:48 PM