Log Shipping Question

All-
Is their a utility that does log shipping? Maybe something
in the SQL 2000 Resource Kit? Or do I have to upgrade to
the Enterprise Edition from my current Standard?
Also, where do I find/install the SQL 2000 Resource Kit?
Thanks,
DH
On the resource kit there is a set of procedures which are unsupported.
Depending on your service agreement, you may already have the disk
containing the resource kit but if not, you can buy it from
Amazon:http://www.amazon.com/exec/obidos/tg...8/103-0789888-
8246260?v=glance
Regards,
Paul Ibison
|||OK, thanks Paul...
Another question.
We would like to have a Hot Standby SQL server at another
site connected via a VPN. What in your opinion is the most
efficient way to replicate 2 SQL servers over a VPN?
Log Shipping? Transactual Replication?
Thanks,
DH
>--Original Message--
>On the resource kit there is a set of procedures which
are unsupported.
>Depending on your service agreement, you may already have
the disk
>containing the resource kit but if not, you can buy it
from
>Amazon:http://www.amazon.com/exec/obidos/tg/detail/-
/0735612668/103-0789888-
>8246260?v=glance
>Regards,
>Paul Ibison
>
>.
>
|||Darius,
transactional replication has lower latency than log shipping, but the 2 are
not entirely equivalent as far as DR goes. Transactional replication won't
take defaults, user defined datatypes, users or permissions - these you'll
need to script out and apply on the subscriber manually. Also, some schema
changes to published articles are not directly allowed - eg changing the
length of a varchar column. If you need it to be more in synch, then
transactional replication is better (using a short pollinginterval value)
but the above issues ned to be taken into account.
Regards,
Paul Ibison
sql

Log Shipping Monitor Reqs

Greetings:
Does anyone know if I can install/run the Log Shipping Monitor Utility on
SQL 2000 Standard Edition, or do I need to actually have THREE copies of SQL
Enterprise Edition in order to configure Log Shipping?
I realize the recommendation is to NOT install the monitor utility on the
source server, but can it be installed on the Destination server?
Thanks!
Keith C. Jakobs, MCP
Hello mate,
You DON'T need to have Enterprise Edition to host the log shipping monitor -
I have and use exactly the model your trying to work towards in my
organisation.
Regards
Paul.
"Keith Jakobs, MCP" wrote:

> Greetings:
> Does anyone know if I can install/run the Log Shipping Monitor Utility on
> SQL 2000 Standard Edition, or do I need to actually have THREE copies of SQL
> Enterprise Edition in order to configure Log Shipping?
> I realize the recommendation is to NOT install the monitor utility on the
> source server, but can it be installed on the Destination server?
> Thanks!
> Keith C. Jakobs, MCP
>
>