Originally Posted by udontknowjack
So what is the difference between the two?
Stolen from MSSQL online help.
The Full Recovery model uses database backups and transaction log backups to provide complete protection against media failure. If one or more data files is damaged, media recovery can restore all committed transactions. In-process transactions are rolled back.
Full Recovery provides the ability to recover the database to the point of failure or to a specific point in time. To guarantee this degree of recoverability, all operations, including bulk operations such as SELECT INTO, CREATE INDEX, and bulk loading data, are fully logged.
With the Simple Recovery model, the database can be recovered to the point of the last backup. However, you cannot restore the database to the point of failure or to a specific point in time. To do that, choose either the Full Recovery or Bulk-Logged Recovery model.
The backup strategy for simple recovery consists of:
Differential backups (optional).
Note This model is similar to setting the trunc. log on chkpt. database option in Microsoft® SQL Server™ version 7.0 or earlier.
To recover in the event of media failure
Restore the most recent full database backup.
If differential backups exist, restore the most recent one.
Changes since the last database or differential backup are lost.