• It seems like a big database. You can also consider 3rd party tools like LiteSpeed which can help you backup/restore one table.

    Ofcourse it is a license tool.

    If licensing is problem , SSIS is the best option.