Home Forums SQL Server 2008 SQL Server 2008 High Availability Mirroring and SQL Agent Job on principle RE: Mirroring and SQL Agent Job on principle
george sibbald
SSC Guru
Points: 104210
More actions
March 15, 2014 at 9:03 am
#1697421
yes you can, from the failover with command
ALTER DATABASE database_name
SET PARTNER = FORCE_SERVICE_ALLOW_DATA_LOSS
---------------------------------------------------------------------