New answers tagged

3

As detailed in this MSDN document, the port number must be unique within any given computer: Note that if more than one server instance on a given computer requires a database mirroring endpoint, specify a different port number for each endpoint. TCP ports can only be served by a single process. When you try to create two endpoints with the same ...


0

Situation 1 So when you restart SQL server while users are connectd & D1 database is 2.5TB so it take's more time to failover then D2 database.Also I assume there will be more activity on D1 then D2 database. As you did unplanned restart of SQL server on bussy database (D1) so mirroring get distructed may be packet loss to mirror server or fail to ...


2

In our case we're using certificate authentication for connecting mirroring endpoints, and the issue was because one of the certificates that the mirroring endpoints were using had expired. You can check the expiration date of the certificate involved in endpoint authentication by doing a SELECT * FROM sys.certificates If this is the case, you'll need ...


0

to me it appears that there is something wrong as the way mirroring has been set up. you could use the query below, on the server where the principal databases are. this would give you some visibility as things have been set up. --============================================================================== -- query that shows the current state of each ...



Top 50 recent answers are included