RE: Database mirroring is disabled by default; need trace 1400

SSC Journeyman

Points: 83

July 12, 2012 at 2:12 am

Sql server 2005 mirroring is having an issue.

giving an error as

SQL SERVER CANNOT CREATE THE MIRRORING ENDPOING 'mirroring'.

Additional Information

Create failed for Endpoing 'Mirroring'. (Microsoft.Sql Server.Smo)

An exceptions occured while executing a Transact-SQL statemetn or batch.

(Microsoft.SqlServer.ConnectionInfo)

Database mirroring is disabled by default.

Database mirroring is currently provided evaluation purposes only and is not to be used in production environments.

To enable database mirroring for evaluation purposes, use trace flag 1400 during startup.

Note:

i am trying to work on VM environment.