How to set Recovery models using T_SQL?

Published on August 18 2015 by LakshmiSaahul,Dhana Royal

How to set Recovery models using T_SQL?

a) To Check current recovery model:- SELECT DATABASEPROPERTYEX('ADVENTUREWORKS', 'RECOVERY') As [Recovery Model]

b) To set Simple Recovery model:- ALTER DATABASE ADVENTUREWORKS SET RECOVERY SIMPLE

c) To set Bulk-Logged Recovery model ALTER DATABASE ADVENTUREWORKS SET RECOVERY BULK_LOGGED

d) To set Full recovery model ALTER DATABASE ADVENTUREWORKS SET RECOVERY FULL

Advertising