Change recovery mode for databases in SQL Server

–Change the recovery mode for databases:

USE master;
GO

— Set recovery model to SIMPLE

ALTER DATABASE Test 
SET RECOVERY SIMPLE;
GO

— Set recovery model to FULL

ALTER DATABASE Test 
SET RECOVERY FULL;
GO

Leave a Reply

Your email address will not be published. Required fields are marked *