November 20, 2012 at 2:25 pm
Hi,
We have configured log shipping in SQL Server 2008 R2.
Primary Server A has a named instance on port 1234
Secondary Server B has a named instance on port 4321
Networks team requesting us to provide what are the ports we are using for Log shipping and I provided Source Server Ip, destination server IP.
But Network admin also wants the port numbers the files are copying, the communication is happening, is the communication bi-directional?
What are SQL Sever items we need to provide to a Network admin when we are using SQL Server Log shipping?
Please advise
Thanks
November 21, 2012 at 3:27 am
Log shipping will not use any Port. Sql Agent will copy t-log backup files from folder to folder. This is one way of communication between two server unless you configure a third Server as Monitor Server.
November 21, 2012 at 3:29 am
+
November 21, 2012 at 3:47 am
You will need to ensure that you have CIFS ports open so that the file copies can take place, ports 135,137,138,139,445 also the SQL ports need to be open. If your doing role switching tests and want to make the secondary primary, primary secondary then ensure that all ports are open bi-directional, if not just ensure that the SQL ports are open bi-directional.
November 21, 2012 at 5:31 am
Mani-584606 (11/20/2012)
Hi,We have configured log shipping in SQL Server 2008 R2.
Primary Server A has a named instance on port 1234
Secondary Server B has a named instance on port 4321
Are you using a dedicated monitor server?
Are both machines on the same domain or in a workgroup?
Mani-584606 (11/20/2012)
But Network admin also wants the port numbers the files are copying, the communication is happening, is the communication bi-directional?What are SQL Sever items we need to provide to a Network admin when we are using SQL Server Log shipping?
Please advise
Thanks
The file copy is initially a one way operation, the secondary pulls from the primary/network backup location.
However, if you role switch as Anthony has mentioned then you'll need to mirror port setups for the file copy operations.
Which ports you need depends how you're copying the files. You can open all the ports Anthony has listed but your firewall admin will probably have a coronary if you ask for that portset 😉 😀
For the filecopy ops are you using IP address, Netbios name or FQDN of the server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply