How to Set All Databases to Simple Recover Model (Logging)



— This script will set recovery model to Simple on all databases
use [master]
go

— Declare variable for each database name
declare @databaseName nvarchar(128)

— Define the cursor
declare databaseCursor cursor

— Define the cursor dataset
for
select [name] from sys.databases

— Start loop
open databaseCursor

— Get information from the first row
fetch next from databaseCursor into @databaseName

— Loop until there are no more rows
while @@fetch_status = 0
begin
print ‘Setting recovery model to Simple for database [‘ + @databaseName + ‘]’
exec(‘alter database [‘ + @databaseName + ‘] set recovery Simple’)

— Get information from next row
fetch next from databaseCursor into @databaseName
end

— End loop and clean up
close databaseCursor
deallocate databaseCursor
go