February 1, 2010 at 7:30 pm
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
February 1, 2010 at 7:39 pm
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.
February 1, 2010 at 8:02 pm
is it possible to enable this service eventhough i dont have the right sp?
thanks,
February 2, 2010 at 2:47 am
Have a read of your original post...yes you can. Just do what is suggested in your post
February 2, 2010 at 2:56 am
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
February 3, 2011 at 4:23 pm
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.
February 4, 2011 at 1:04 am
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
July 12, 2012 at 2:12 am
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
July 12, 2012 at 2:57 am
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
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply