Backing up SQL Server is a standard practice, but knowing which recovery model to use can be confusing. Use these tips to get started with your backup strategy.

No recovery up to the point of failure as with the Full recovery model. You see, we cannot use the transaction log for recovery with the Simple recovery model.