This one I try to use it as something to learn how to move large amounts of data, so I do not mind spending some time doing it, will try the bcp path, thanks
for the filegroup it had a separate file, was set offline, it is possible to remove the filegroup but not the physical file, when I try to do that I get this:
Msg 5056, Level 16, State 2, Line 1
Cannot add, remove, or modify a file in filegroup 'FG_lost' because the filegroup is not online.