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

USE master
GO

DECLARE @name VARCHAR(50) -- database name
DECLARE @recoveryMode VARCHAR(50) -- recovery mode
DECLARE @sql NVARCHAR(500)
 
DECLARE db_cursor CURSOR FOR
SELECT name
FROM master.dbo.sysdatabases
WHERE name NOT IN ('master','msdb','tempdb') -- exclude these databases

OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @name

WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @recoveryMode = recovery_model_desc FROM sys.databases
WHERE name = @name

IF (@recoveryMode != 'SIMPLE')
BEGIN
       SET @sql = 'ALTER DATABASE ' + @name + ' SET RECOVERY SIMPLE WITH NO_WAIT;'
       EXECUTE sp_executesql @sql
END 

FETCH NEXT FROM db_cursor INTO @name
END

 
CLOSE db_cursor
DEALLOCATE db_cursor