I want to back up my DB. I have some huge tables in some specific
FileGroups which I want to exclude them to be getting
I have tried this script:
BACKUP DATABASE TestDB FILEGROUP = 'PRIMARY', FILEGROUP = 'Temp_FG', FILEGROUP = 'Index_FG' TO DISK = 'E:\TestBackup\Test.bak'; GO
But I am getting this error:
The primary filegroup cannot be backed up as a file backup because the database is using the SIMPLE recovery model. Consider taking a partial backup by specifying READ_WRITE_FILEGROUPS.
What can I do to get the backup including only these 3 FileGroups or excluding the 'Dump_FG'?
- 'Dump_FG' FileGroup is not