Which are the recovery models in SQL Server 2k ?
The recovery model is a database property. It defines the method you wish to use when recovering your database; depending on the mode you select, different amounts of information will be preserved for each backup.
Simple recovery: This option restores a database to its state at the time of its most recent backup. Any changes made after the last full or differential backup are lost (no transaction log backups are made).
Full recovery: This option restores a database to its state at the point of failure.
Bulk-logged recovery: This option enables bulk-logged operations, which means that certain database operations, such as SELECT INTO operations or BCP/Bulk Copy, will be logged minimally or not at all. The risk of data loss is higher than with the full-recovery model, as bulk-logged recovery does not provide point-in-time recovery
