TABLE 1: Relationship Between Database Options and Recovery Models
If trunc. log on chkpt. is: And select into/bulkcopy is: The recovery model is:
FALSE FALSE FULL
FALSE TRUE BULK_LOGGED
TRUE FALSE SIMPLE
TRUE TRUE SIMPLE