• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2677
  • Last Modified:

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
0
JaimeJegonia
Asked:
JaimeJegonia
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
0
 
JaimeJegoniaAuthor Commented:
AngelIII

It works for me.

Thanks,
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now