Hello,

We have a scenario where I need to back up a specific file group from Server A and restore the file group on to Server B(the DB name and files/filegroups are same), really not sure if this is possible. We are thinking this approach to copy a big table from one server to other server instead of SSIS which is taking many hours.

FYI: This table in is in separate file group.

Please anyone let me know if it is possible to backup a file group on Server A and restore it on to Server B on the same database name.

Thanks,

Shyam.

Hi Shyam,

We cannot restore the specific file group from Server A to an existing database in Server B. When restoring the file group to an existing database in Server B, you will get the following error message.

The supplied backup is not on the same recovery path as the database, and is ineligible for use for an online file restore.

However, we can restore file group from Server A to a new database in Server B, for more details, please review the example in this blog.

In your scenario, besides using SSIS, you can also consider to use BULK INSERT as the table is large.

There is also a similar thread for your reference.
http://www.sqlservercentral.com/Forums/Topic412470-357-1.aspx

Thanks,
Lydia Zhang

If you have any feedback on our support, please click here.