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 ;