log shipping encryption

I have a few questions that are bugging me, being a newbie to SQL 2000
Enterprise. I want to set up a warm site server for disaster recovery of my
production server at a remote location. Both Sql servers will be behind
firewalls, (if that matters) and the remote site will not be a production
server; only receiving the shipped transaction logs and being updated
accordingly. For budgetary reasons, they are Internet attached via T1.
1. Is this setup possible?
2. If so, will SQL2000 allow me to encrypt the data it is shipping?
3. Why can't the Chiefs find a defense that will hold the other team to
less than 35 points so I can get rid of my ulcer?
Hoping for all three answers, but hey...2 out of 3 is still a good average.
Thanks in advance.
Hi
The setup is possible.
SQL does not support encryption at transport level, that function belongs to
the OS or network stack. You could connect the 2 servers via Windows VPN.
Setup the dial-up VPN, originating from the local server, to use the network
cards, with no-hangup, and auto-retry.
The VPN then can run compression (big benefit as most log files can be
compressed by up to 70%) and encryption.
Windows VPN is very efficent and is great for security needs like yours.
Regards
Mike
"Rod Hurley" wrote:

> I have a few questions that are bugging me, being a newbie to SQL 2000
> Enterprise. I want to set up a warm site server for disaster recovery of my
> production server at a remote location. Both Sql servers will be behind
> firewalls, (if that matters) and the remote site will not be a production
> server; only receiving the shipped transaction logs and being updated
> accordingly. For budgetary reasons, they are Internet attached via T1.
> 1. Is this setup possible?
> 2. If so, will SQL2000 allow me to encrypt the data it is shipping?
> 3. Why can't the Chiefs find a defense that will hold the other team to
> less than 35 points so I can get rid of my ulcer?
> Hoping for all three answers, but hey...2 out of 3 is still a good average.
> Thanks in advance.