Hi,

I have two instances in two different DC's ,Hence communication between Instances not possible(Telnet/Ping),But we can move any files using Server Message Block (SMB) folders.

Please let me know if any possibilities configuring log shipping using SMB folder.

Regards,

1)  keep share folder as Server Message Block (SMB) folders

2) Need have access as system admin on both instance.

3) keep database in full recovery models.  also refer

https://www.mssqltips.com/sqlservertip/2562/sql-server-log-shipping-to-a-different-domain-or-work

Using SMB you can enable file share.

The service account that your SQL agent on primary is required write permissions

secondary server SQL agent need read permissions.

-----------------------------------------------------------

another thought usually transaction logs are copied by primary server SQL agent using windows copy command.

If you have any issues running your SMB copy commands from agent here is the alternative method.

prepare your script and save it as a batch file and schedule this using task manager to transfer and place it in the required folder.

• Edited by Kumar muppa Monday, July 06, 2015 6:53 AM
• Proposed as answer by Lydia ZhangMicrosoft contingent staff, Moderator 47 minutes ago

Hi MyWish,

Besides other post, if you configure log shipping over firewall in the scenario that using SMB, please note that the following ports should be open. For more details, please review this blog.

Netbios over TCP/IP is enabled

 TCP ports 137,139

 UDP ports 137,138

Direct Hosting of SMB over TCP/IP

 TCP port 445

There is also a similar thread about network ports for log shipping configuration for your reference.
http://www.experts-exchange.com/questions/28201018/Cannot-Connect-to-Log-shipping-Secondary-Server-from-primary-server-during-congiguration.html



Thanks,
Lydia

The answer is yes.

1. On primary site: create log shipping backup job and backup transaction log to \\serverPrimary\folderPrimary

2. Use SMB to copy all files under \\servername\folderPrimary to a path in secondary site: \\fileServerSecondary\folderSecondary

3. On secondary site log shipping secondary server, configure log shipping copy job copy file from \\fileServerSecondary\folderSecondary to a local path (ex: E:\sqlserver\logshipping) of this log shipping secondary server.

4. On secondary site log shipping secondary server, configure log shipping restore job to get log files from the folder we configured in the last step (ex: E:\sqlserver\logshipping).