镜像异步

--批量更改镜像异步DECLARE @sql VARCHAR(MAX)SET @sql = ''DECLARE @db VARCHAR(20)DECLARE cursors CURSORFOR    SELECT  name    FROM    sys.databases    WHERE   name IN ( 'A', 'B', 'C', 'D' )OPEN cursorsFETCH NEXT FROM cursors INTO @dbWHILE @@FETCH_STATUS = 0     BEGIN         IF EXISTS ( SELECT  1                    FROM    sys.database_mirroring                    WHERE   mirroring_safety_level = 2 )             SET @sql = @sql + 'ALTER DATABASE ' + @db + ' SET SAFETY OFF;'                + CHAR(10)           FETCH NEXT FROM cursors INTO @db   END    IF @sql <> ''BEGINEXEC (@sql)PRINT CHAR(10)+'镜像数据库安全设置已更改'+CHAR(10)END --PRINT @sqlCLOSE cursorsDEALLOCATE cursors