quote:

---

Originally posted by Marcelo Blasco

Hi.

We have a database in SQL 2005 with 2 filegroups:
- PRIMARY, containing the main data (about 15 GB)
- SECONDARY, containing 3 tables (about 6 GB). This filegroup can be recreated based on the data of PRIMARY and exists just to improve performance and control access rights. Data in this tables are recreated as needed every time a user logs into the application.

Right now, the recovery model is set to Simple, which is not acceptable anymore. We want to move to Full recovery model. Since secondary filegroup is based on data in the primary filegroup, we would like to just backup the primary filegroup. We know that after the restore process, the data in secondary will have to be recreated, but it's something acceptable. So the idea was just to create full and differential backups of the primary filegroup and transaction logs.

Now the questions:
1) How do we restore a database without including the secondary filegroup? We can restore the backups from the primary filegroup, but would the transaction log backups include everything done in the secondary filegroup?

Yes, With Peacemeal Database Restore you can restore Primary FG . Tran log backup captures changes in Primary FG.

2) Would it be possible to have a backup of the secondary filegroup without any data (just the table structures) and restore it with the restored data from the primary filegroup?

Your question is not clear.Yes, you can backup Secondary Fg and restore it after Primary FG has been restored which contains important system metadata.


Thanks in advance for any advice on the backup/restore plans on this specific case.

---