Recovery in sql

Question

Hi What is default recovery model for SQL Server? Thanks

Gaurang Upadhyay · Answer

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.