Various options available for recovery model in SQL SERVER

In This post we are going to see some various options available for recovery model in SQL SERVER.

 Full, Bulk-logged, Simple

         

          Full : No work is lost, due to failure. It is default recovery model.

          Bulk-logged : Allows high-performance bulk copy operations. Minimum space    

                               is required , we can perform recovery when have taken the     

                                  backup of the database.

          Simple: Allows high-performance bulk copy operations,  we can perform  

                        recovery when we have taken the backup,advantage of using this is  

                        minimumspace requirement.

From this post you can learn what the available options for recovery model in SQL SERVER