The server network address “TCP://SQLServer:5023” can not be reached or does not exist.

Tags: SQL Server, Mirroring

Wednesday, July 26, 2017 4:38:41 AM

The server network address “TCP://SQLServer:5023” can not be reached or does not exist.

1 Comment

  • verasearch3 said Reply

    You can manually remove the destination server from mirroring with:

    ALTER DATABASE AdventureWorks2014 SET PARTNER OFF;

    Or restore it with:

    RESTORE DATABASE AdventureWorks2014 WITH RECOVERY;

    Since it will have been restored in NORECOVERY mode originally and will be unusable.

You must log on to comment.