Setting up Log shipping between 2 SQLServer on Internet
zaj
Posts: 8
Hello there,
I am trying to setup Log Shipping between two SQL server 2008 database. They are on different network. One is in the datacenter and one is in our office. I installed the RedGate Backup at the datacenter side. Now the stage where I nee dto give a network path. I have placed a Seagate NAS at my office and created a folder called redgate which i gave read,write access. Now when I enter the static IP of the NAS like so, \38.45.123.154
edgate i get folder does not exists.
On the datacenter server when i enter this IP in the RUN of windows,it opens the folder window. What am I missing,please help!!
cheers
ZOlf
I am trying to setup Log Shipping between two SQL server 2008 database. They are on different network. One is in the datacenter and one is in our office. I installed the RedGate Backup at the datacenter side. Now the stage where I nee dto give a network path. I have placed a Seagate NAS at my office and created a folder called redgate which i gave read,write access. Now when I enter the static IP of the NAS like so, \38.45.123.154
edgate i get folder does not exists.
On the datacenter server when i enter this IP in the RUN of windows,it opens the folder window. What am I missing,please help!!
cheers
ZOlf
Comments
generate the log notify the destination destination: copy the log restore the log on the source: maintain space by deleting transaction logs older than 72 hours or .... destination: cleanup the copied transaction logs
orDB mirroring might become a possibility
You are trying to use the NAS as an intermediary.
and this will only get you to a point of having the DBs in sync with one being in recovery mode, getting you back on how you would access the data there.
Reference :
http://www.experts-exchange.com/questio ... dgate.html