Recovery in sql

SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options. The three disaster recovery models offered by SQL Server are:

• Simple Recovery Model
• Full Recovery Model
• Bulk-logged Recovery Model

Please checked Below Link :

http://databases.about.com/od/sqlserver/a/recoverymodels.htm

Now to choose one model selection

http://weblogs.asp.net/jgalloway/archive/2006/12/17/sql-server-recovery-model-selection-or-what-s-this-3gb-ldf-file.aspx

Thanks & Regards
Gaurang Upadhyay
Sr Developer.