Log Shipping on two different networks.

Hi,
I have two servers with MS SQL Server 2000 Enterprise Edition
installed on it. These two servers are on different networks, means you
can say that these two servers are having two different network
segments.
Now, i want to configure Log Shipping on these two servers. Here
my doubt is can we setup Log Shipping on these servers.
Thanks & Regards,
MS SQL DBA.I believe so, as it's all based on tcp/ip and filesharing.
We log ship over a wan to a 3rd party data centre. We are using custom
scripts are we are using SqlLiteSpeed to compress the logs.
We have a BDC at the remote site to handle authentication.
Paul
<csajid@.gmail.com> wrote in message
news:1162464539.029111.215840@.h54g2000cwb.googlegroups.com...
> Hi,
> I have two servers with MS SQL Server 2000 Enterprise Edition
> installed on it. These two servers are on different networks, means you
> can say that these two servers are having two different network
> segments.
> Now, i want to configure Log Shipping on these two servers. Here
> my doubt is can we setup Log Shipping on these servers.
>
> Thanks & Regards,
> MS SQL DBA.
>|||csajid@.gmail.com wrote:
> Hi,
> I have two servers with MS SQL Server 2000 Enterprise Edition
> installed on it. These two servers are on different networks, means you
> can say that these two servers are having two different network
> segments.
> Now, i want to configure Log Shipping on these two servers. Here
> my doubt is can we setup Log Shipping on these servers.
>
> Thanks & Regards,
> MS SQL DBA.
>
If you can copy files between the two servers, you can log ship between
them. Log shipping is nothing more than doing a backup on Server A,
copying that backup to Server B, then restoring it on Server B.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi All,
Thanks for your reply.
One of my concern is that, there is any need to open specific
port to do the Log Shipping.
Thanks & Regards,
Sajid C.
Tracy McKibben wrote:
> csajid@.gmail.com wrote:
> If you can copy files between the two servers, you can log ship between
> them. Log shipping is nothing more than doing a backup on Server A,
> copying that backup to Server B, then restoring it on Server B.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Hi All,
Thanks for your reply.
One of my concern is that, there is any need to open specific
port to do the Log Shipping.
Thanks & Regards,
Sajid C.
Tracy McKibben wrote:
> csajid@.gmail.com wrote:
> If you can copy files between the two servers, you can log ship between
> them. Log shipping is nothing more than doing a backup on Server A,
> copying that backup to Server B, then restoring it on Server B.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||I believe file sharing in over
TCP 139
TCP 445
UDP 137
UDP 138
Make sure you can see the shared folders.
As our log shipping is based on exec'ing remote stored procs I need port
1433 for Sql Server.
Paul
<csajid@.gmail.com> wrote in message
news:1162549383.086499.183990@.h48g2000cwc.googlegroups.com...
> Hi All,
> Thanks for your reply.
> One of my concern is that, there is any need to open specific
> port to do the Log Shipping.
>
> Thanks & Regards,
> Sajid C.
> Tracy McKibben wrote:
>|||Hi Paul,
Thanks for your reply.
Thanks & Regards,
Sajid C.
Paul Cahill wrote:[vbcol=seagreen]
> I believe file sharing in over
> TCP 139
> TCP 445
> UDP 137
> UDP 138
> Make sure you can see the shared folders.
> As our log shipping is based on exec'ing remote stored procs I need port
> 1433 for Sql Server.
> Paul
>
> <csajid@.gmail.com> wrote in message
> news:1162549383.086499.183990@.h48g2000cwc.googlegroups.com...|||Hi Paul,
Thanks for your reply.
Thanks & Regards,
Sajid C.
Paul Cahill wrote:[vbcol=seagreen]
> I believe file sharing in over
> TCP 139
> TCP 445
> UDP 137
> UDP 138
> Make sure you can see the shared folders.
> As our log shipping is based on exec'ing remote stored procs I need port
> 1433 for Sql Server.
> Paul
>
> <csajid@.gmail.com> wrote in message
> news:1162549383.086499.183990@.h48g2000cwc.googlegroups.com...