March 3, 2010 at 12:48 am
Hi
I created Two instance on my system named A and B i am using
SQL Server 2005 - 9.00.1399.06 (Intel X86) Developer Edition on Windows NT 6.0 (Build 6001: Service Pack 1). i tried Database Mirroring but it shows
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. (.Net SqlClient Data Provider)
So i tried to start the MY server with -T1400
Real One:
-----------
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
Changed One:
-------------
-T1400C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
and then it says restart your server, i did restart but the thing is it does not again start, it shows Time out
What is the reason for this, how can i do mirroring any other possible ways
Thanks
Parthi
Thanks
Parthi
March 3, 2010 at 2:03 am
Few questions :
Are both the instances on same machine?
Are you trying to implement mirroring first time on them ?
Have you tried Wizard for mirroring ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 4:23 am
Bhuvnesh (3/3/2010)
Few questions :Are both the instances on same machine?
Are you trying to implement mirroring first time on them ?
Have you tried Wizard for mirroring ?
Yes i am using Same system with instance A and B
Yes i am trying to implementing it for first time
ya i have tried wizard in that only error coming.
Have you done mirroring,have you faced this type of problem,have you over come this ,got the solution if so how
Thanks
Parthi
March 3, 2010 at 4:26 am
Can you post exact Error you got ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2010 at 5:15 am
I have given my error details in my 1st post itself
again i am sending
TITLE: Microsoft SQL Server
------------------------------
SQL Server cannot create the mirroring endpoint, 'Mirroring'.
------------------------------
ADDITIONAL INFORMATION:
Create failed for Endpoint 'Mirroring'. (Microsoft.SqlServer.Smo)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
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. (Microsoft SQL Server, Error: 1498)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1498&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Thanks
Parthi
March 3, 2010 at 5:51 am
parthi-1705 (3/3/2010)
SQL Server cannot create the mirroring endpoint, 'Mirroring'.ADDITIONAL INFORMATION:
----------------------------------------------------------------------------------
Create failed for Endpoint 'Mirroring'. (Microsoft.SqlServer.Smo)
TRy few things ;
1) Try to telnet your port for mirroring point.
2) Have you restarted sql services ?
3) Enable trace 1400 on both principal and mirror instance and then start the SQL server .
RTM version will not support mirroring without this trace flag else update SP3 for both your instances.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply