Tuesday, April 24, 2012

Changing recovery mode for all databases

-- Changing recovery mode for all databases
declare @dbname varchar(30), @sql varchar(max)
declare dbcur cursor for select name from sys.databases where database_id not in (1, 2,3,4)
open dbcur
fetch next from dbcur into @dbname
while @@FETCH_STATUS = 0 and @@ERROR = 0
begin
 set @sql = ' alter database ' + @dbname + ' set recovery simple'
 print @sql
 fetch next from dbcur into @dbname
end
close dbcur
deallocate dbcur

No comments:

Post a Comment