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 Problem

I am implementing Log Shipping. I have the transaction logs copying to
the standby server and applying to the standby database with no errors.

However, I am having problems with the role change. I am using the
following article/link as my guide:
http://msdn.microsoft.com/library/d..._1_013_9t0p.asp

The DTS package that I am to create to copy the logins from the current
primary server to the current secondary server is not working.

The job that I created (that encompasses BCP Out, Copy File, and
Transfer Logins) fails at the Transfer Logins step. That is the step
that calls the DTS package. Even though the Copy File step shows as
'successful', the file is definitely not on the standby server.

Here is the error message from the Transfer Login step:
Executed as user: SERVERNAME\Administrator. DTSRun: Loading...
DTSRun: Executing... DTSRun OnStart:
DTSStep_OMWCustomTasks.OMWTransferLogins_1 DTSRun OnError:
DTSStep_OMWCustomTasks.OMWTransferLogins_1, Error = -2147467259
(80004005) Error string: Unspecified error Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 700 Error Detail Records:
Error: -2147467259 (80004005); Provider Error: 0 (0) Error
string: Unspecified error Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp
Help context: 700 DTSRun OnFinish:
DTSStep_OMWCustomTasks.OMWTransferLogins_1 DTSRun: Package execution
complete. Process Exit Code 1. The step failed.

Both servers are running Server 2003. Both databases are SQL Server
2000 with SP3.

I have followed the steps in the article. Am I missing something? Or,
have I misinterpreted something? I would appreciate any help you could
provide.

Thanks in advance,
JennieI purchased Allan Hirt's "SQL Server 2000 High Availability" last
night. It has an entire chapter (72 pages!) devoted to log shipping. It
has slightly different instructions for setting up the
post-configuration tasks - as compared to the Microsoft article that I
had been following. His instructions work!

If you are implementing log shipping, I highly recommend this book!

Jennie