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
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?