November 11, 2009 at 1:04 am
Hello Experts
While configuring the SQL Server Mirroring on the SQL Server 2005, getting the error. "Need urgent assistance."
The following steps have been performed.
(1) I have 3 servers: COE-PC, COE-PC\Distributor and COE-PC\Homedepot.
(2) Created a database: sourav in the principal server(COE-PC) which I want to mirror to the Mirror Server(COE-PC\homedepot).
(3) Created the full bkp, differential backup and log backup of the DB (sourav) from the Principal server and kept those files to a 'share folder' in C$.
(4) Tried to restore the full and differential bkp of the database to the mirror server (same database name). Now it is showing as "sourav(Restoring...)".
(5) Before performing all the above steps, I enabled the trace for the flag: 1400 to all the 3 servers: Principal, Witness and Mirror servers.
dbcc traceon (1400)
(6) Manually created the end points to all the 3 servers:
CREATE ENDPOINT endpoint_mirroring
STATE = STARTED
AS TCP ( LISTENER_PORT = 5022 ) -- Principal
FOR DATABASE_MIRRORING (
AUTHENTICATION = WINDOWS KERBEROS,
ENCRYPTION = SUPPORTED,
ROLE=ALL);
CREATE ENDPOINT endpoint_mirroring
STATE = STARTED
AS TCP ( LISTENER_PORT = 5023 ) -- Witness
FOR DATABASE_MIRRORING (
AUTHENTICATION = WINDOWS KERBEROS,
ENCRYPTION = SUPPORTED,
ROLE=ALL);
CREATE ENDPOINT endpoint_mirroring
STATE = STARTED
AS TCP ( LISTENER_PORT = 5024 ) -- Mirror
FOR DATABASE_MIRRORING (
AUTHENTICATION = WINDOWS KERBEROS,
ENCRYPTION = SUPPORTED,
ROLE=ALL);
(7) Then I started configuring the security by right clicking the Database from the Principal server and mirror option. That setup was configured correctly.
(8) Once when I click on "Start Mirroring", I'm getting the below error:
(see the attached files..)
Pls suggest how to proceed now and configure the Mirrored Server using the witness.
Thanks.
November 11, 2009 at 1:46 am
Hi,
Apply Sql server service pack 2 or 3; Problem will resolved.
In your attached file it is showing Sql server version 9.0.1399 in which Database Mirrioring is not enabled.
Rd,
Deepali
November 12, 2009 at 3:03 am
Thanks Dipali.
By the way, can you send me the steps to configure the mirroring and also to do the failover(if you have prepared one doc for your reference)?
I'm trying the same for the first time. The doc will be much hlpful to me.
Thanks.
November 12, 2009 at 3:13 am
Go through below link it has every possible thing about SQL2K5 mirroring in there.
http://technet.microsoft.com/en-us/library/cc917680.aspx
Asif
November 12, 2009 at 5:25 am
Hi,
Find the DB mirrioring doc...for details refer books online
Rd,
Deepali
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply