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