Let's say, I have a database
myModel2015 that contains two file groups -
Primary A and
Secondary Read-Only B. Then, I am creating a partial backup of the secondary file group.
Now, let's create a new
myModel database (there might be difference in the database objects in the primary file group, but the tables in the read-only file group will be the same as this in the
Is it possible to perform piecemeal restore of the
Secondary Read-Only B file group but using the new database?