February 9, 2015 at 5:11 pm
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.
February 9, 2015 at 6:39 pm
Did you consider using SQL Server Import and Export Wizard?
February 9, 2015 at 6:49 pm
Thanks for your reply, however it take many hours to do a Import/Export.
The table size is 20GB.
I tried to take the filegroup backup and I am able to restore the filegroup on to other server but I am not able to bring the filegroup online, so just thought of checking whether I am doing correct.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply