Advertisement
private775

SQL: set recovery to simple

Jan 26th, 2016
297
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.50 KB | None | 0 0
  1. USE [master]
  2. DECLARE @name NVARCHAR(MAX) -- database name  
  3.  
  4. declare db_cursor CURSOR FOR  
  5. SELECT name
  6. FROM MASTER.sys.databases
  7. WHERE name NOT IN ('master','model','msdb','tempdb') and recovery_model_desc <> 'SIMPLE'
  8.  
  9. OPEN db_cursor  
  10. FETCH NEXT FROM db_cursor INTO @name  
  11.  
  12. WHILE @@FETCH_STATUS = 0  
  13. BEGIN  
  14.    
  15.     PRINT 'ALTER DATABASE [' + @name + '] SET RECOVERY SIMPLE WITH NO_WAIT'
  16.     PRINT 'GO'
  17.     FETCH NEXT FROM db_cursor INTO @name  
  18. END  
  19.  
  20. CLOSE db_cursor  
  21. DEALLOCATE db_cursor
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement