Task 2: Define the database recovery model

Critical to a backup and recovery strategy for SQL Server databases is the SQL Server setting for Recovery Model. The Microsoft MSDN website provides a good definition of the different backup options. The following are excerpts from the website. For more information, see the topic "Recovery Models (SQL Server)" on the Microsoft SQL Server Docs website.