3

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?

Thomas Stringer
42.5k9 gold badges120 silver badges155 bronze badges
asked Oct 16, 2014 at 11:41

1 Answer 1

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"

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

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.