Database mirroring is disabled by default; need trace 1400

  • good day everyone,

    I tried mirroring our server; but it gives me a message that mirroring optiob is disabled; please see message below;

    Msg 1498, Level 16, State 2, Line 4

    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.

    how can i enble trace 1400?

    Thanks in advance

  • in the RTM release of SQL 2005, mirroring was disabled as you are finding - database mirroring in the release is not supported by Microsoft.

    This was changed in Sp1 (and all subsequent service packs) - mirroring is enabled by default and is fully support by Microsoft. So, download and install the latest service pack.

  • is it possible to enable this service eventhough i dont have the right sp?

    thanks,

  • Have a read of your original post...yes you can. Just do what is suggested in your post

  • Install SQL 2005 SP3. You should not be running RTM any longer.

    Traceflag 1400 was provided for testing only. Don't use it in production environment, not supported (but then neither is 2005 RTM any longer)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Hi Gali,

    I am having an issue in setting up Mirroring in my laptop. Currently i'm using sql server standard edition 2005 sp3. When i'm trying to set up the mirroring and hit start mirroring i'm getting this message plz refer to the attachment. Let me know how i should troubleshoot it. I did some googling but i couldn't find anything and now i'm pretty confused where i should start and what i have to do. Plz suggest me something.

  • Please post new questions in a new thread. Your error is unrelated to the one described here.

    Thank you.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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.

    Pls. contact me selvan2115@yahoo.com

  • You're running SQL 2005 RTM. Patch to SP4.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply