Table 2: Results of SELECT INTO Operation
Database Recovery Model Duration (Seconds) Database Transaction-Log Size Transaction-Log Backup Size
Simple 8.5 < 4MB Not allowed
Bulk_Logged 8.5 < 4MB ~40MB
Full 14 ~40MB ~40MB