What backup/restore strategy can I use for the following scenario We have two databases on a server which are being synced using back up and restore on a scheduled basis. Now, we would like to exclude a few tables getting affected by the back up and restore process. 

What is the best way of doing this using backup and restore ?

I tried keeping the tables that should not be affected in a secondary file group and performing a file group back up and restore. 

I ran into various issues during the restore process.

The following message was appeared while restoring the PRIMARY file group:

The roll forward start point is now at log sequence
number (LSN) 507000000318400006. Additional roll forward past LSN
507000000318400006 is required to complete the restore sequence.
Gone through some online content and tried restoring the last log backup and got the following     message:


This backup set cannot be applied because it is on a recovery path that is inconsistent with the database. 

And then I ran into the following article in sqlservercentral

http://www.sqlservercentral.com/blogs/dotnine-sql-server-and-more/2014/02/20/restoring-filegroup-backups-on-another-server-and-why-it-wont-work/

Question 1: How can I exclude few tables from syncing during a backup and restore process?

Question 2: According to article, I cannot achieve this using backup/restore. I that correct?

Thank you...
You cannot exclude parts of the database from backup and restore in the sense that those parts disappear or just become empty. SQL Server requires that all filegroups are either current or offline. You can bring non-current offline filegroups online by making them current by restoring enough backups.

A database is an inseparable entity when it comes to data and consistency.

If you could empty partitions/tables by not restoring them you could break trusted foreign keys and indexed views.