• There are several options:

    * recreating the table like you did before, but not with SELECT INTO, and using the simple recovery model.

    * updating the table in batches: do the update statement for e.g. 10000 rows at a time.

    * maybe you can temporarily disable/drop the indexes and recreate them after the update statement.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP