How to set a manual failover using Database Mirroring

-- Works on SQL Server 2005

ALTER DATABASE <database name>

SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.