79 million is quite a amount. Though you can try following things-
1. Go with scripting (still I think, it'd fail)
2. Go with
SELECT * INTO
statement
SELECT * INTO [db-name].new-table-name
FROM [db-name].table-name [WHERE condition]
You can try to insert few records at a time and follow the same again. I'd suggest you to use
ROW_NUMBER[
^] and
WHILE
loop to give it a go.
I have done with around 83K records
KR