----------------------
EXECUTE
sp_MSforeachdb
'
IF
(''?'' NOT IN (''master'', ''tempdb'', ''msdb'', ''model''))
EXECUTE (''ALTER DATABASE [?] SET RECOVERY SIMPLE WITH NO_WAIT'') '
---------------------
In this example, I`ve used "SET RECOVERY SIMPLE WITH NO_WAIT", but you can use any other.
No comments:
Post a Comment