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