So this is my set up. In our data warehouse we have mostly tables that are filled with data from a ETL-process. We do not take backup of these tables since we have an option to do a full reset using ETL. We also have a couple of tables with historical data. These are valuable and need to be backed up.
What I did was to split the historical tables into a separate filegroup and do a backup of this filegroup pretty often.
Then comes the trouble. I want to restore this. Since the historical filegroup are newer than the primary, I'm unable to restore it because I get a SLN error. I have simple recovery mode on the database.
In case of a data crash my thought was to restore the primary filegroup (consisting of empty tables) than restore the newest historical filegroup with the latest data, then start the reset action of my ETL.
Any ideas or solutions to how I can manage to to this? I'm running MSSQL Server 2014