–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
–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