Mirroring issue kindly help needed

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Mirroring issue kindly help needed

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2008-04-25 : 05:52:55

Trying to create mirroring in SQL Server 2005. I followed the steps through Security Wizard. For miror server instance connect I used
'SA' login and pwd..I m not using witness..as i clicked on finish I got below error.
On pricipal server i got error message but on mirror server I got success message.

error message:

TITLE: Microsoft SQL Server
------------------------------
SQL Server cannot create the mirroring endpoint, 'Mirroring'.
------------------------------
ADDITIONAL INFORMATION:
Create failed for Endpoint 'Mirroring'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Endpoint&LinkId=20476
------------------------------
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.1406&EvtSrc=MSSQLServer&EvtID=1498&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

Select @@version for Principal server is
Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Mar 3 2007 18:40:02 Copyright (c) 1988-2005
Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Select @@version for Mirror server is
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005
Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

I searched some google pages and got information that I need to enable DB Mirroring.
I followed To configure startup options : and add -T 1400 there and restart service.

also run T-SQL

CREATE ENDPOINT [Mirroring]
AS TCP (LISTENER_PORT = 5022)
FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = ENABLED);

but getting error
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'ENABLED'.

also this
ALTER ENDPOINT [Mirroring] STATE = STARTED
still get error:
Msg 1088, Level 15, State 100, Line 1
Cannot find the object "Mirroring" because it does not exist or you do not have permissions.

Nothing i m seeing on Principal server but getting onw row on mirror server

SELECT * FROM sys.database_mirroring_endpoints;

But still it didnt work for me

One more thing what happened if i did

ALTER ENDPOINT [Mirroring] STATE = STOPPED

on mirror server?? Mirror server remain as it is as it was before doing all above steps???

Any kind help...

T.I.A

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-25 : 11:32:37

Your error indicates Principle Sql server doesn't have SP1. Are you sure about that? You don't need to enable trace flag -1400 if you have SP1 or upper.

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2008-04-28 : 00:21:52

Select @@version for Principal server is
Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Mar 3 2007 18:40:02 Copyright (c) 1988-2005
Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

What else i check for it....

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-28 : 21:50:21

Version number of sql2k5 sp1 is 9.00.2047.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources