Sunday, 12 February 2017

Types of Recovery Models available in SQL Server ?

In SQL server there are 3 different types of recovery models.
Each database mush be selected to any of these 3 recovery models.

Following are the types of recovery models used in SQL server.

Simple
Full
Bulk-Logged

T-SQL to change the recovery model of a database

ALTER DATABASE DATABASE_NAME
SET RECOVERY [Full / Simple / Bulk-Logged]

No comments:

Post a Comment