Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database mirroring is disabled by default; need trace 1400 Expand / Collapse
Author
Message
Posted Monday, February 01, 2010 7:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 06, 2010 2:30 AM
Points: 23, 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
Post #857682
Posted Monday, February 01, 2010 7:39 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:21 PM
Points: 2,842, Visits: 2,423
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.



Post #857684
Posted Monday, February 01, 2010 8:02 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 06, 2010 2:30 AM
Points: 23, Visits: 117
is it possible to enable this service eventhough i dont have the right sp?

thanks,
Post #857688
Posted Tuesday, February 02, 2010 2:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:21 PM
Points: 2,842, Visits: 2,423
Have a read of your original post...yes you can. Just do what is suggested in your post


Post #857792
Posted Tuesday, February 02, 2010 2:56 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:30 PM
Points: 41,531, Visits: 34,448
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 2008, MVP
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

Post #857797
Posted Thursday, February 03, 2011 4:23 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:57 PM
Points: 56, Visits: 576
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.


  Post Attachments 
Screen shot 2011-02-03 at 4.18.21 PM.png (26 views, 11.66 KB)
Post #1058456
Posted Friday, February 04, 2011 1:04 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:30 PM
Points: 41,531, Visits: 34,448
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 2008, MVP
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

Post #1058534
Posted Thursday, July 12, 2012 2:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 2:27 AM
Points: 5, 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
Post #1328714
Posted Thursday, July 12, 2012 2:57 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:30 PM
Points: 41,531, Visits: 34,448
You're running SQL 2005 RTM. Patch to SP4.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1328735
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse