How to troubleshoot Database mirroring?
by barkkathulla[ Edit ] 2012-09-18 17:34:35
Problem WITH Explanation
Error Message 1418
This SQL Server message forms that the server network address will not be reached and it suggests that you verify the network address name and rectify that command.
Accounts
Discusses requirements for correctly configuring the accounts under which Structure Query Language Server is running.
Endpoints
Discusses requirements for correctly configuring the database mirroring endpoint of each server instance.
SystemAddress
Summarizes the alternatives for specifying the system name of a server instance in a database mirroring configuration.
Network access
Documents the requirement that each the server instance be able to access the ports of the other server instance or instances over TC Protocol
Mirror database preparation
Summarizes the requirements for preparing the mirror database to enable mirroring to start
Failed create-file operation
Describes how to respond to a failed create-file operation.
Starting mirroring by Using Transact-SQL
Describes the required order for ALTER DATABASE database_name SET PARTNER = 'partner_server' statements.
Cross-Database Transactions
An automatic failover could lead to automatic and possibly incorrect resolution of in-doubt transactions.