Log Shipping Across Domains

We have a secure environment containing a SQL cluster, and wish to use
log shipping to ship data out to a reporting server. For various
reasons, this reporting server lives in another Win2k domain, outside
of the OLTP environment, and the two are separated by a firewall.
We don't want to set up any trusts between the domain, so what we're
trying to achieve is log shipping across two non-trusting domains.
Testing so far fails upon 'initializing destination', presumably
because the source server(s) can't write to the share on the
desintation server.
Does anyone know if what we're trying to achieve is possible, or if
there might be another solution (using something like ftp, for
example)?
Any thoughts or suggestions great appreciated,
Glen
I would go for "rolling your own" version of Log Shipping (it would not be
that difficult) and perhaps using FTP to transfer the logs. Can you do
that?
Here's one article on the subject.
http://www.sql-server-performance.co..._shipping.asp. I'd
google for more.
hth
Eric
<gsmithnospam@.cafonline.org> wrote in message
news:com8b011jv09mbomcb24fvtt3h918i730c@.4ax.com...
> We have a secure environment containing a SQL cluster, and wish to use
> log shipping to ship data out to a reporting server. For various
> reasons, this reporting server lives in another Win2k domain, outside
> of the OLTP environment, and the two are separated by a firewall.
> We don't want to set up any trusts between the domain, so what we're
> trying to achieve is log shipping across two non-trusting domains.
> Testing so far fails upon 'initializing destination', presumably
> because the source server(s) can't write to the share on the
> desintation server.
> Does anyone know if what we're trying to achieve is possible, or if
> there might be another solution (using something like ftp, for
> example)?
> Any thoughts or suggestions great appreciated,
> Glen
|||Thanks Eric - looks like that's our only option!
Glen
On Wed, 26 May 2004 09:14:45 -0400, "Eric Sabine"
<mopar41@.___ho_y_tmail.ScPoAmM> wrote:

>I would go for "rolling your own" version of Log Shipping (it would not be
>that difficult) and perhaps using FTP to transfer the logs. Can you do
>that?
>Here's one article on the subject.
>http://www.sql-server-performance.co..._shipping.asp. I'd
>google for more.
>hth
>Eric
>
><gsmithnospam@.cafonline.org> wrote in message
>news:com8b011jv09mbomcb24fvtt3h918i730c@.4ax.com.. .
>