July 10, 2009 at 3:06 am
Hello All ,
Can you please tell me about database mirroring configuration setup
I have created principal and mirror servers and before that i have done following step
Principal Server ( Which is on remote server)
-take a backup
-save it on principal server
-copy it to mirror server
Mirror Server [ Which is my local system)
-Restore the database .
I only restore the .Bak only and unable to restore the .log file (it gives error)
After that i have done the following steps
1)Right Click +Properties+Mirroring
2)Click on Configure Security+Next
3)I dont want WITNESS
4)Next
5)It automatically display Port no 5022 and EndPoint : Mirroring for principal and Mirror Server respectively.
6)I will give Service Account as
xxxx\administartor(for Principal)
and xxxx\sarang (for Mirror)
7)It gives successful message
8)But when click on Start Mirroring Button following error message is displayed
The server network address "TCP://indserver.xxxx.local:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)
so any on ecan please send me exact solution over this
April 7, 2010 at 3:21 pm
Start with restore with NO RECOVERY. If you are going to mirror the mirror database must be in no recovery mode.
Raymond Laubert
Exceptional DBA of 2009 Finalist
MCT, MCDBA, MCITP:SQL 2005 Admin,
MCSE, OCP:10g
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply