Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @DBName AS NVARCHAR(128)
- DECLARE @SQL AS NVARCHAR(200) ;
- DECLARE DBCursor CURSOR FAST_FORWARD FOR
- SELECT
- D.name
- FROM
- sys.database_mirroring M
- JOIN
- sys.databases D
- ON
- M.database_id = D.database_id
- WHERE
- mirroring_role_desc = 'PRINCIPAL'
- OPEN DBCursor
- FETCH NEXT FROM DBCursor
- INTO @DBName ;
- WHILE @@FETCH_STATUS = 0
- BEGIN
- PRINT 'Failing over ' + @DBName + '...' ;
- SELECT @SQL = 'ALTER DATABASE ' + @DBName + ' SET PARTNER FAILOVER' ;
- EXEC(@SQL) ;
- FETCH NEXT FROM DBCursor
- INTO @DBName
- END
- CLOSE DBCursor ;
- DEALLOCATE DBCursor ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement