Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Database Design and Application Architecture  Filegroups - backup/restore and log shipping

Author  Topic  iamtig Starting Member 3 Posts Posted - 2009-12-01 : 11:53:13 I have a reporting database that populated every 15 minutes via log shipping. The database is very large and I am in the process of implementing filegroups to use for data that is not needed for reporting which can be very large. I was looking into the posability that I could restore only the needed filegroups and save space on reporting by not restoring the non-reporting data. 1. Looking at the database backup/restore, it appears that I cannot specify a filegroup when restoring over another database using a replace. 2. If I could restore only the needed filegroups, would affect would this on log shipping? Has anyone every attempted to do anything like this?