| 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 |
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.