>If you're using FULL Recovery model and accidentally run wrong command (say, instead of select used DELETE )) then you would be able to restore your database to the time before this wrong command occurred and all other transactions would be saved. With simple recovery model you can not do this.
>
>That's a simplistic explanation of the difference between recovery models.
Thanks