June 29, 2011 at 8:26 am
Hi,
I have two filegroups FG1 and FG2 and they have 2 datafiles each. Now I want to use only FG2 filegroup backup on another database. I dont want any other data, I want to use only FG2 filegroup data on another new database. How can I restore so that only FG2 filegroup data can be visible to other users.
Thanks in advance.
June 29, 2011 at 9:46 am
Which FILEGROUP is the PRIMARY?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 29, 2011 at 11:32 am
FG1 is primary one.
June 29, 2011 at 11:57 am
As I understand it (not an expert at backup/restore) you cannot restore a secondary filegroup unless the primary has already been restored. If you need this sequence regularly I would advise you to move most of your data out of primary filegroup FG1 (maybe into a new FG3) so you can more easily backup and restore FG1, and then that will allow you to restore FG2 after that.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 29, 2011 at 1:06 pm
With Enterprise edition you can do piecemeal restore, meaning you can restore only some of the non-primary file groups. The primary file group has to always be restored and it has to be the first one restored (it has the system tables in it)
Hence in your case you have to restore both as FG2 is the only non-primaryfilegroup you have
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply