Posts Tagged ‘remote’

Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.

Four exceptions must be configured in Windows Firewall to allow access to SQL Server:

  1. A port exception for TCP Port 1433. In the New Inbound Rule Wizard dialog, use the following information to create a port exception:
    • Select Port
    • Select TCP and specify port 1433
    • Allow the connection
    • Choose all three profiles (Domain, Private & Public)
    • Name the rule “SQL – TCP 1433”
  2. A port exception for UDP Port 1434. Click New Rule again and use the following information to create another port exception:
    • Select Port
    • Select UDP and specify port 1434
    • Allow the connection
    • Choose all three profiles (Domain, Private & Public)
    • Name the rule “SQL – UDP 1434
  3. A program exception for sqlservr.exe. Click New Rule again and use the following information to create a program exception:
    • Select Program
    • Click Browse to select ‘sqlservr.exe’ at this location:
       
[C:\Program Files\Microsoft SQL Server\MSSQL11.<INSTANCE_NAME>\MSSQL\Binn\sqlservr.exe] where <INSTANCE_NAME> is the name of your SQL instance.  
  • Allow the connection
  • Choose all three profiles (Domain, Private & Public)
  • Name the rule SQL – sqlservr.exe
  • A program exception for sqlbrowser.exe Click New Rule again and use the following information to create another program exception:
    • Select Program
    • Click Browse to select sqlbrowser.exe at this location: [C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe]. 
    • Allow the connection
    • Choose all three profiles (Domain, Private & Public)
    • Name the rule SQL – sqlbrowser.exe
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Recently I wanted to copy a load of files from a server to a Synology NAS. 

You can use Synology GUI to map a remote file using SMB with a username and password. You can then reference that folder for an RSYNC copy to do the inital sync then copy changes 

The RSYNC Command is below

rsync –archive –progress –verbose –inplace –exclude ‘*@SynoResource’ –exclude ‘@eaDir’ –exclude ‘*.vsmeta’ –exclude ‘.DS_Store’ ‘/volume1/Remote/Dir/’ ‘/volume1/Dir/’ >> /volume1/DIR/log1.txt 2>&1

Just to show you –Archive is equals -rlptgoD (no -H,-A,-X)  , so it will overwrite newer files with the older ones so only use the above for the initial sync

To replicate the rest when the new volume is being used do

rsync -rlptgoDu –progress –verbose –inplace –exclude ‘*@SynoResource’ –exclude ‘@eaDir’ –exclude ‘*.vsmeta’ –exclude ‘.DS_Store’ ‘/volume1/Remote/Dir/’ ‘/volume1/Dir/’ >> /volume1/DIR/log1.txt 2>&1

 

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)