I am using SQL Server 2008R2 (but I can upgrade if necessary)
I have a database with multiple schemas and each schema is on a different filegroup (I wish I could just backup/restore a schema but that doesn't seem to be possible).
The recovery model is full.
I am performing backups of the filegroups.
How do I perform a filegroup to a previous state (without affecting the data on other filegroups?). When I try to restore a file group I need to restore the transaction log which adds all changes since the last backup.
Is what I am asking even possible?