I am working a database with a size of 325 GB total. Out of this a single table Documents is occupying 321 GB storage and the rest of the 84 table occupy the remaining space. As the database is growing rapidly, taking backups is consuming a lot of space. In most of the scenarios Documents table is not required to be backed up.
So we created a new filegroup and moved the Clustered Index with primary key of the Documents Table only to the secondary filegroup. Despite this when we take the PRIMARY filegroup backup with Backup Type set as FULL, we are also getting all the SECONDARY filegroup records.
How can we take backups of the PRIMARY filegroup without including the Document table? Also I noticed that despite creating the new index in SECONDARY filegroup, it's file size is still the same when it was created, and it is not reflecting the size of the Documents table.