Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 can we restore only single file group ie Secondary

Author  Topic 

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2013-03-02 : 10:20:17
We are facing some issues while restoring filegroups:-

We have 2 Databases, DBTEST1 and DBTEST2.
Under DBTEST1 we have only one primary filegroup and in DBtest2 we have 2 filegroups ie Primary and secondary.

SO my question is can we restore only single file group ie Secondary from DBTest2 to DBTest1.

Kamran Shahid
Principle Engineer Development
(MCSD.Net,MCPD.net)

   

- Advertisement -