sql-server-maintenance-solution icon indicating copy to clipboard operation
sql-server-maintenance-solution copied to clipboard

Add support for file group backup

Open olahallengren opened this issue 10 months ago • 0 comments

I'm working on adding support for file group backup.

Usage:

EXECUTE dbo.DatabaseBackup
@Databases = 'WideWorldImporters',
@Directory = 'C:\Backup',
@BackupType = 'FULL',
@Verify = 'Y',
@FileGroups = 'WideWorldImporters.USERDATA, WideWorldImporters.USERDATA2',
@NumberOfFiles = 4

Outstanding issues:

  • The primary filegroup cannot be backed up if the database is in the SIMPLE recovery model.
  • The primary filegroup and any memory-optimized filegroup must be backed up together.

I need to add handling of these cases.

olahallengren avatar Jun 08 '25 18:06 olahallengren