SQL Server Errors or Failures Error: 1412 to Error: 1431



Error: 1412, Severity: 16,
The remote copy of database “%.*ls” has not been rolled forward to a point in time that is encompassed in the local copy of the database log.

Error: 1413, Severity: 16,
Communications to the remote server instance ‘%.*ls’ failed before database mirroring was fully started. The ALTER DATABASE command failed. Retry the command when the remote database is started.

Error: 1414, Severity: 16,
The database is being closed before database mirroring is fully initialized. The ALTER DATABASE command failed.

Error: 1415, Severity: 16,
The database mirroring operation for database “%.*ls” failed. The requested operation could not be performed.

Error: 1416, Severity: 16,
Database “%.*ls” is not configured for database mirroring.

Error: 1417, Severity: 16,
Database mirroring has been disabled by the administrator for database “%.*ls”.

Error: 1418, Severity: 16,
The server network address “%.*ls” can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

Error: 1419, Severity: 16,
The remote copy of database “%.*ls” cannot be opened. Check the database name and ensure that it is in the restoring state, and then reissue the command.

Error: 1420, Severity: 16,
Database mirroring was unable to obtain the network hostname. Operating system error %ls encountered. Verify the network configuration.

Error: 1421, Severity: 16,
Communications to the remote server instance ‘%.*ls’ failed to complete before its timeout. The ALTER DATABASE command may have not completed. Retry the command.

Error: 1422, Severity: 16,
The mirror server instance is not caught up to the recent changes to database “%.*ls”. Unable to fail over.

Error: 1423, Severity: 16,
The property name is not supported.

Error: 1424, Severity: 16,
The remote server instance has a more recent value for the property ‘%.*ls’. Property value not changed.

Error: 1425, Severity: 16,
The property value is invalid for ‘%.*ls’. Property value not changed.

Error: 1426, Severity: 16,
To issue ALTER DATABASE SET WITNESS, all three server instances must be interconnected, and the mirror database must be caught up. When these conditions are met, reissue the command.

Error: 1427, Severity: 16,
The server instance ‘%.*ls’ could not act as the witness. The ALTER DATABASE SET WITNESS command failed.

Error: 1428, Severity: 16,
The request is refused because the responding server instance is not in a state to service the request.

Error: 1429, Severity: 16,
The witness server instance name must be distinct from both of the server instances that manage the database. The ALTER DATABASE SET WITNESS command failed.

Error: 1430, Severity: 16,
Database ‘%.*ls’ is in an unstable state for removing database mirroring, so recovery may fail. Verify the data after recovery.

Error: 1431, Severity: 16,
Neither the partner nor the witness server instance for database “%.*ls” is available. Reissue the command when at least one of the instances becomes available.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.


Leave a Reply

Your email address will not be published. Required fields are marked *