Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [master]
- DECLARE @name NVARCHAR(MAX) -- database name
- declare db_cursor CURSOR FOR
- SELECT name
- FROM MASTER.sys.databases
- WHERE name NOT IN ('master','model','msdb','tempdb') and recovery_model_desc <> 'SIMPLE'
- OPEN db_cursor
- FETCH NEXT FROM db_cursor INTO @name
- WHILE @@FETCH_STATUS = 0
- BEGIN
- PRINT 'ALTER DATABASE [' + @name + '] SET RECOVERY SIMPLE WITH NO_WAIT'
- PRINT 'GO'
- FETCH NEXT FROM db_cursor INTO @name
- END
- CLOSE db_cursor
- DEALLOCATE db_cursor
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement