<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SS2K5 Replication
»
Database mirroring is disabled by default;...
Database mirroring is disabled by default; need trace 1400
Rate Topic
Display Mode
Topic Options
Author
Message
cute_lhen05
cute_lhen05
Posted Monday, February 01, 2010 7:30 PM
Grasshopper
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
happycat59
happycat59
Posted Monday, February 01, 2010 7:39 PM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 9:55 PM
Points: 2,471,
Visits: 2,066
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
cute_lhen05
cute_lhen05
Posted Monday, February 01, 2010 8:02 PM
Grasshopper
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
happycat59
happycat59
Posted Tuesday, February 02, 2010 2:47 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 9:55 PM
Points: 2,471,
Visits: 2,066
Have a read of your original post...yes you can. Just do what is suggested in your post
Post #857792
GilaMonster
GilaMonster
Posted Tuesday, February 02, 2010 2:56 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:38 AM
Points: 37,726,
Visits: 29,987
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
sam-1083699
sam-1083699
Posted Thursday, February 03, 2011 4:23 PM
Valued Member
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:52 PM
Points: 56,
Visits: 544
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
(
24 views,
11.66 KB
)
Post #1058456
GilaMonster
GilaMonster
Posted Friday, February 04, 2011 1:04 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:38 AM
Points: 37,726,
Visits: 29,987
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
thamaraiselvan
thamaraiselvan
Posted Thursday, July 12, 2012 2:12 AM
Forum 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
GilaMonster
GilaMonster
Posted Thursday, July 12, 2012 2:57 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:38 AM
Points: 37,726,
Visits: 29,987
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
