You can define or change the Recovery Model for MSSQL Server using SQL Server Management Studio. Expand the databases tree, right click on the database instance and select Properties.
Under Options page, you can choose the Recovery Model from the list.
Simple
• No log backups
• Overwrite log backups
• Small space required
• Possible of data loss (since recovery rely on backup)
• Can recover to the end of a backup
Full
• Log backups enable
• Space consumed
• No data loss
• Can recover to a specific time
Bulk logged
• Log backups enable
• Reduce log space (minimal logging)
• Can recover to the end of a backup
