RECOVERY MODELS V2K
There are three types of recovery models you can use to back up and 
restore your critical databases. These are the FULL, BULK_LOGGED, and 
SIMPLE models. The option is set from the recovery option tab in 
enterprise manager on each database.

FULL 
The FULL model is the safest method to use in the event of data file 
corruption. Use this model if you wish to recover to a point in time, 
up to the last transaction log backup, or up to the last transaction. 
Of 
course, success is dependent upon whether your transaction log is still 
valid and if you have been making regular database and transaction log 
backups. This model also retains BCP, BULK INSERT, and CREATE INDEX 
operations. The downside to this model is that your transaction log 
backups can be time and space intensive.

BULK_LOGGED 
This method allows for full recovery of a database as well as BCP, BULK 
INSERT, CREATE INDEX, WRITE/UPDATE TEXT, and SELECT INTO operations.  
The difference between the FULL mode and BULK_LOGGED mode is that 
BULK_LOGGED logs that one of these operations has taken place and logs 
the actual extent of changes that were affected.

SIMPLE 
This model only allows for full and differential database backups.  
Since SQL Server truncates the transaction log at regular intervals, 
the log is not needed during the recovery operation.

------------------------------------------