I have a database with three file groups, Primary, FG_ExtendedTables, and FG_ReportingTables.
I need to create another database (production db let's say), and restore only specific file groups and its tables with its data
I've seen this answer on stackoverflow https://stackoverflow.com/questions/25841822/backup-and-restore-sql-server-database-filegroup but he's restoring the .bak file, I did like the example he provided but the bak file has all tables and I don't want that.
is that even possible ? if no, what is the purpose of the file groups then ?
I appreciate if code is provided, thank you.