Short 2 liner to set the recovery mode to simple on all databases:
Use master
select ‘ALTER DATABASE ‘ + name + ‘ SET RECOVERY SIMPLE’ from sys.databases where recovery_model_desc’SIMPLE’;
Short 2 liner to set the recovery mode to simple on all databases:
Use master
select ‘ALTER DATABASE ‘ + name + ‘ SET RECOVERY SIMPLE’ from sys.databases where recovery_model_desc’SIMPLE’;