Restoring filegroup to a brand new database

WingSzeto · Dec 16, 2011

Our regular database contain 1 default primary group and my user defined file group. I know I can do the backup of just that user defined file group. I am wondering if I can restore just that user defined file group to a new database (different database name) in the same SQL server. In other words, the new database would only contain that filegroup and I don't want the primary group from the original database. Is it possible?

W

Luis Martin · Dec 17, 2011

As far I know, no. Wait for other members.

satya · Dec 23, 2011

Take a look at books online about filegroup and file restore option in this case, however you must ensure that data is stored in userdefined FG than in primary so you can have a partial recovery of database. Some links for your study: http://msdn.microsoft.com/en-us/library/ms190984.aspx & http://msdn.microsoft.com/en-us/library/aa196613(v=sql.80).aspx

Log in or Sign up

Restoring filegroup to a brand new database

WingSzeto Member

Luis Martin Moderator

satya Moderator

Share This Page