Home Forums SQL Server 2008 SQL Server 2008 High Availability Multiple endpoint on one witness server(Mirroring), Is it possible? How? RE: Multiple endpoint on one witness server(Mirroring), Is it possible? How?

  • May 17, 2011 at 1:52 pm

    #1326112

    I am also trying to setup Mirroring with failover, the witness instance is on the same server as the mirror instance. My mirror has the default instance name, and my witness is named SQLWitness. How do I specify the following command, it will not allow me to name the instance.

    ALTER DATABASE MainDB

    SET WITNESS = 'TCP://MirrorDB\SQLWitness:5033';

    GO