JaimeJegonia
asked on
SQL SERVER 2005 MIRRORING PROBLEM
Dear Experts,
When I try to setup Database Mirorring for SQL Server 2005 Standard Vesrion, I got thie error. There's an instruction to use trace flag to enable it but it doesn't help. Please help.
Thanks.
ERROR ++++++++++++++++++++++++++ ++++++++++ ++++++++++ ++++++++++ ++++++++++ ++++++++++ ++++
Database mirroring is disabled by default. Database mirroring is currently provided for 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. For more information about trace flags and startup options, see SQL Server Books Online. (Microsoft SQL Server, Error: 1498)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1498&LinkId=20476
When I try to setup Database Mirorring for SQL Server 2005 Standard Vesrion, I got thie error. There's an instruction to use trace flag to enable it but it doesn't help. Please help.
Thanks.
ERROR ++++++++++++++++++++++++++
Database mirroring is disabled by default. Database mirroring is currently provided for 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. For more information about trace flags and startup options, see SQL Server Books Online. (Microsoft SQL Server, Error: 1498)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1498&LinkId=20476
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It works for me.
Thanks,