将服务器上的所有数据库设置为simple恢复模式的SQL

USE masterGODECLARE @name VARCHAR(50) -- database nameDECLARE @recoveryMode VARCHAR(50) -- recovery modeDECLARE @sql NVARCHAR(500) DECLARE db_cursor CURSOR FORSELECT nameFROM master.dbo.sysdatabasesWHERE name NOT IN ('master','msdb','tempdb') -- exclude these databasesOPEN db_cursorFETCH NEXT FROM db_cursor INTO @nameWHILE @@FETCH_STATUS = 0BEGINSELECT @recoveryMode = recovery_model_desc FROM sys.databasesWHERE name = @nameIF (@recoveryMode != 'SIMPLE')BEGIN       SET @sql = 'ALTER DATABASE ' + @name + ' SET RECOVERY SIMPLE WITH NO_WAIT;'       EXECUTE sp_executesql @sqlEND FETCH NEXT FROM db_cursor INTO @nameEND CLOSE db_cursorDEALLOCATE db_cursor