Table 3: Results of UPDATE Operation
Database Recovery Model Duration (Seconds) Database Transaction-Log Size Transaction-Log Backup Size
Simple 18 230MB Not allowed
Bulk_Logged 18 230MB ~54MB
Full 18 230MB ~54MB