–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