We help IT Professionals succeed at work.

SQL SERVER 2005 MIRRORING PROBLEM

JaimeJegonia
JaimeJegonia asked
on
Medium Priority
2,711 Views
Last Modified: 2008-09-09
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
Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
did you enable the trace flag on startup or using DBCC TRACEON? Latter is the wrong method, you have to use the /T startup flag:
http://msdn2.microsoft.com/en-US/library/ms188396(SQL.90).aspx
http://support.microsoft.com/?kbid=907741

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
AngelIII

It works for me.

Thanks,
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.