sql server replication:
Hi all,
I've been racking my brains here, maybe some one can provide some
explanation.
Scenario:
SQL2000 Ent. Ed. on three servers, A B & C
SQL A - Located in Datacenter 1 (Primary)
SQL B - Located in Datacenter 1 (Secondary, Warm Standby, LS Monitor)
These two are set up for same site failover in case of hardware failure.
SQL C - Location in Datacenter 2 (Secondary, Warm Standby)
This location is set up as disaster recovery location in another city/state.
Datacenters 1 & 2 are connected via IPSEC tunnel over WAN in different
cities and *all* servers are registered in *all* EM and resolving each other
fine, shares accessible, etc...
Problem:
If I use the Database Maintenance Wizard and create Log Shipping Plan for a
DB between (SQL A <-> SQL B) it works fine and everything is nice. If I
then go to the Log Shipping tab of the Maint Plan and attempt to use the
"Add" button to ADD an additional server and specify the settings for the
SQL C server at Datacenter 2, I recieve an Error on the initialization when
it tries to copy the initial backup over to server:
"unable to copy the initialization file to the secondary server
'<server_name>'"
Now, if I delete the plan, start over and specify *both* SQL B *and* SQL C
as secondary servers using the Maint. Plan Wizard again from scratch it then
goes through, initializes and sets up *both* secondaries fine. I end up
with SQL A log shipping to SQL B and SQL C and everything is nice.
The interesting part is that if I attempt to use SQL Query Analyzer
(xp_cmdshell) to copy to the init.bak file from the Primary (SQL A) over to
SQL C it succeeds without error.
Questions:
Why would it work when I configure from the Maint. Plan wizard, but fail
when I try to ADD from the Log Shipping tab ?
How do I troubleshoot whether this error message and failure when attempting
to *ADD* additional LS secondaries to the existing Maint Plan is a bug, or
some other obscure permission problem ?
I've seen the KB article that describes this condition on a SQL Cluster with
two different domain, however I'm using neither. All three SQL servers are
part of the same workgroup, and are using the Admin account with identical
passwords for the SQL Server Service and SQL Server Agent.
Thanks in advance.
Frank
