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?

1 Answer 1


A filegroup restore can be done on a database in FULL recovery model. There are requirements and consequences of the restore.

  1. You must be using Enterprise Edition.
  2. The primary filegroup must be the first restore.
  3. Filegroups that are not yet restored remain offline.

Start reading at this topic in MSDN: http://msdn.microsoft.com/en-us/library/ms177425(v=sql.105).aspx

Read the topic: "Piecemeal Restore Under the Full Recovery Model"

  • Also if I remember correctly you can restore individual read-only filegroups but have to restore all of the read/write filegroups together. Oct 16, 2014 at 13:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.