While configuring database mirroring we encountered below error message with GUI and in SQL Server Error Log   GUI Error:  Error : Database Mirroring login attempt by user ‘Domain\Login’ failed with error: ‘Connection handshake failed. The login ‘Domain\Login’ does not have CONNECT permission on the endpoint. State 84.’. [CLIENT: xx.xx.xx.xxx] Reason : Normally this error popup […]

DECLARE @MirroredDBToTest sysname SET @MirroredDBToTest = DB_NAME() DECLARE @MirroringResults TABLE (database_name sysname, role int, mirroring_state int, witness_status int, log_generation_rate int, unsent_log int, send_rate int, unrestored_log int, recovery_rate int, transaction_delay int, transactions_per_sec int, average_delay int, time_recorded datetime, time_behind datetime, local_time datetime) INSERT INTO @MirroringResults EXEC msdb..sp_dbmmonitorresults @database_name = @MirroredDBToTest SELECT DATEDIFF(S,time_behind, time_recorded) AS Latency FROM @MirroringResults

Error : The server network address “TCP://SQL Server:5022” cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418) To over come the issue follow the below steps. Drop the Mirroring Endpoints from Principal and Secondary. select […]

Couple of days back I was working for a client on creating a database mirroring monitor report to show how log is being sent to DR in last hour or so. How much log is left to be sent based on the send rate and how long will it. Stored Procedure sp_dbmmonitorresults in msdb database gives all […]

select DB_NAME(database_id) dbname,CASE mirroring_safety_level WHEN 0 THEN ‘Unknown’ WHEN 1 THEN’asynchronous’ WHEN 2 THEN ‘synchronous’ END from sys.database_mirroring

If we configure Database mirroring for Synchronous mode where principal waits for an acknowledgement from the mirror server before settling a commit or rollback, what would happen if the mirror server fails? When transaction safety is set to FULL, the database mirroring session runs in high-safety mode and operates synchronously after an initial synchronizing phase. […]