June 20, 2011 at 5:57 am
Hi, I try to mirror a database, 1) i took full backup from serverA and trn backup. 2) create new db and restore database backup as bak & trn.
and there is wintness server.
OS:Windows 2008 - 64bits.
SQL: SQL 2008 with sp1.
3 Different computer's with seperate disk.
A) ServerA backup on F:\BackupMirrorData\ took full and tlog backup there.
Copy backup from F:\ drive to H:\Mirror backup
B) ServerB restore from H:\Mirror backup for full and tlog backup.
When i try to create a mirror, so i get a default setting on mirror and port taken 5022 for all include wintness server too. I want to change listener port from 5022 to other on but i cant do that. Note: principle, mirror and witness are 3 different instances on the different server, i want to use diffrerents ports.
Have a look at on image, let me know if you have any further question.
thnx
June 20, 2011 at 6:58 am
see this document! http://msdn.microsoft.com/en-us/library/ms189852.aspx
it's overview of mirror database! and the following link: http://msdn.microsoft.com/en-us/library/ms189921.aspx for connections between servers of mirror!
June 21, 2011 at 1:29 am
Hi,
that not help me at all. You can see in PrtScr, i cant able to change Listener port or Endpoint name: all come as default setting. I need help to ride off default setting, please help.
thx
June 21, 2011 at 1:36 am
Hi Again,
I forget to mention that, i have Principle server instance (seperate machine), Mirror Server Instance(seperate machine), AND Witness server Instance(seperate machine), All 3 machine running OS: Windows 2008 and SQL Server 2008.
Let me know if you have wondering.
thnx
June 21, 2011 at 5:27 am
rather than using the mirroring "gui" in SSMS, perhaps you can change the parameters in a script. go thru the mirroring setup in the gui, with the 5022 ports, and before you click OK to create the mirror, use the Script button at the top to write it out to a script file. you should be able to edit the ports and change it there. then run it in query analyzer.
i haven't confirmed this in practice but in theory it should work.
June 21, 2011 at 5:33 am
i did tests to create mirror and according with print screen, i can to change the port of communication between servers!!!!
this link, by TechNet, is step-by-step to create mirror: http://technet.microsoft.com/en-us/library/ms189047.aspx
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply