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
将服务器上的所有数据库设置为simple恢复模式的SQL
最新推荐文章于 2023-10-06 20:41:01 发布