2 added 45 characters in body
source | link

This is explained here, it boils down to that you have to have a full backup of the databases as well as a backup of the read-only filegroups:

A piecemeal restore sequence restores and recovers a database in stages at the filegroup level, beginning with the primary and all read/write, secondary filegroups.

In this example, a database named adb, which uses the simple recovery model, contains three filegroups. Filegroup A is read/write, andprimary filegroup, filegroup B and and filegroup C are read-only. Initially, all of the filegroups are online.

  1. Do a partial restore of the primary and filegroup A from a partial backup.

    At this point the primary filegroup and filegroup A are online. Files in filegroups B and C are recovery pending, and the filegroups are offline.

  2. Online recovery of filegroup C.

    Filegroup C is consistent because the partial backup that was restored above was taken after filegroup C became read-only

  3. Restore of filegroup B.

    Files in filegroup B must be restored. The database administrator restores the backup of filegroup B taken after filegroup B became read-only and before the partial backup.

So in your case. Do a Partitial backup of of the Primary filegroup and the Read/Write filegroup and restore that with recovery. The RO file will be recovery pending and then you can restore that filegroup with recovery to get the database up to date and then reload the data.

This is explained here, it boils down to that you have to have a full backup of the databases as well as a backup of the read-only filegroups:

A piecemeal restore sequence restores and recovers a database in stages at the filegroup level, beginning with the primary and all read/write, secondary filegroups.

In this example, a database named adb, which uses the simple recovery model, contains three filegroups. Filegroup A is read/write, and filegroup B and filegroup C are read-only. Initially, all of the filegroups are online.

  1. Do a partial restore of the primary and filegroup A from a partial backup.

    At this point the primary filegroup and filegroup A are online. Files in filegroups B and C are recovery pending, and the filegroups are offline.

  2. Online recovery of filegroup C.

    Filegroup C is consistent because the partial backup that was restored above was taken after filegroup C became read-only

  3. Restore of filegroup B.

    Files in filegroup B must be restored. The database administrator restores the backup of filegroup B taken after filegroup B became read-only and before the partial backup.

So in your case. Do a Partitial backup of of the Primary filegroup and restore that with recovery. The RO file will be recovery pending and then you can restore that filegroup with recovery to get the database up to date and then reload the data.

This is explained here, it boils down to that you have to have a full backup of the databases as well as a backup of the read-only filegroups:

A piecemeal restore sequence restores and recovers a database in stages at the filegroup level, beginning with the primary and all read/write, secondary filegroups.

In this example, a database named adb, which uses the simple recovery model, contains three filegroups. Filegroup A is read/write, primary filegroup, filegroup B and filegroup C are read-only. Initially, all of the filegroups are online.

  1. Do a partial restore of the primary and filegroup A from a partial backup.

    At this point the primary filegroup and filegroup A are online. Files in filegroups B and C are recovery pending, and the filegroups are offline.

  2. Online recovery of filegroup C.

    Filegroup C is consistent because the partial backup that was restored above was taken after filegroup C became read-only

  3. Restore of filegroup B.

    Files in filegroup B must be restored. The database administrator restores the backup of filegroup B taken after filegroup B became read-only and before the partial backup.

So in your case. Do a Partitial backup of of the Primary filegroup and the Read/Write filegroup and restore that with recovery. The RO file will be recovery pending and then you can restore that filegroup with recovery to get the database up to date and then reload the data.

1
source | link

This is explained here, it boils down to that you have to have a full backup of the databases as well as a backup of the read-only filegroups:

A piecemeal restore sequence restores and recovers a database in stages at the filegroup level, beginning with the primary and all read/write, secondary filegroups.

In this example, a database named adb, which uses the simple recovery model, contains three filegroups. Filegroup A is read/write, and filegroup B and filegroup C are read-only. Initially, all of the filegroups are online.

  1. Do a partial restore of the primary and filegroup A from a partial backup.

    At this point the primary filegroup and filegroup A are online. Files in filegroups B and C are recovery pending, and the filegroups are offline.

  2. Online recovery of filegroup C.

    Filegroup C is consistent because the partial backup that was restored above was taken after filegroup C became read-only

  3. Restore of filegroup B.

    Files in filegroup B must be restored. The database administrator restores the backup of filegroup B taken after filegroup B became read-only and before the partial backup.

So in your case. Do a Partitial backup of of the Primary filegroup and restore that with recovery. The RO file will be recovery pending and then you can restore that filegroup with recovery to get the database up to date and then reload the data.