SQL Server – Backup Type for Each Recovery Model

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-General, Varinder Sandhu

Before looking about Backup type for each Model, sharing with brief information about Recovery and Recovery Model

Recovery

Recovery options determine the behavior of transaction log and how damaged pages are handled.

Recovery Model

Every database within a SQL server a SQL server instance has a property setting called recovery model. The recovery model determines the types of backups you can perform against a database. The recovery models available in SQL server 2008 are:

  • Full
  • Bulk-Logged
  • Simple

Related Posts

, , , ,