ALTER DATABASE [Database Name] SET PARTNER FAILOVER
Be mindful - this can ONLY be done from the principal, not the mirror. If the principal is unavailable, the mirror can be forced to start up, but there is a possibility of data loss:
ALTER DATABASE [Database Name] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
Credit where credit is due: http://www.sqlservercentral.com/Forums/Topic829941-1549-1.aspx
No comments:
Post a Comment