Home > Uncategorized > Set recovery model to simple

Set recovery model to simple

June 20, 2011

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’;

%d bloggers like this: