Link to home
Start Free TrialLog in
Avatar of JaimeJegonia
JaimeJegoniaFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JaimeJegonia

ASKER

AngelIII

It works for me.

Thanks,