SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database mirroring is disabled by default; need trace 1400


Database mirroring is disabled by default; need trace 1400

Author
Message
cute_lhen05
cute_lhen05
SSC Journeyman
SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)

Group: General Forum Members
Points: 77 Visits: 117
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
happycat59
happycat59
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5468 Visits: 3253
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.



cute_lhen05
cute_lhen05
SSC Journeyman
SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)

Group: General Forum Members
Points: 77 Visits: 117
is it possible to enable this service eventhough i dont have the right sp?

thanks,
happycat59
happycat59
SSCertifiable
SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)SSCertifiable (5.5K reputation)

Group: General Forum Members
Points: 5468 Visits: 3253
Have a read of your original post...yes you can. Just do what is suggested in your post



GilaMonster
GilaMonster
SSC Guru
SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)

Group: General Forum Members
Points: 114259 Visits: 45481
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


sam-1083699
sam-1083699
SSC-Enthusiastic
SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)

Group: General Forum Members
Points: 113 Visits: 649
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.
Attachments
GilaMonster
GilaMonster
SSC Guru
SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)

Group: General Forum Members
Points: 114259 Visits: 45481
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


thamaraiselvan
thamaraiselvan
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 18
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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)SSC Guru (114K reputation)

Group: General Forum Members
Points: 114259 Visits: 45481
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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search