sql server replication:
Last week I made the following post....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Running Win 2003 & SQL 2005 on both machines.
I created a publication on serverA. I subscribed to it on serverB. I
received the error....
Command attempted:
E:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\REPLDATA\unc\unc\R99S-SQLA_DBMOTO_AS400 MASTER
FILES\20061206113840\APVENDP_2.sch
(Transaction sequence number: 0x000049A200000088002A00000000, Command
ID: 16)
Error messages:
The device is not ready.
Thinking that replication was attempting to access the snapshot
locally, I changed to the location of the snapshot in the subscription
to \\serverA\E$\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\REPLDATA\unc\unc\R99S-SQLA_DBMOTO_AS400 MASTER
FILES\20061206113840\APVENDP_2.sch
Note that the location of the snapshot is .....repldata\unc\unc\.... in
the error message. I browsed to serverA & there is no
.....repldata\unc\unc folder, just a ....repldata\unc folder, then the
folder R99S-SQLA_DBMOTO_AS400 MASTER FILES.
Next I changed the location of the snapshot to reflect where the
subscription was looking ....repldata\unc\unc & now the subscription is
initialized & receiving transactions from the publisher.
With all that said.....does anyone know why I had to jump through these
back flips to get replication to work when I did not deviate from the
defaults??
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hilary posted the following
It sounds like your default snapshot share location was not specified
correctly. I think it was the double unc which gave you this error
message.
I take it this is a pull, if that is the case you don't need to use a
UNC.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This tells me what the problem is but does not give me any directing in
resolution.
How do I fix this?? I do not want to have to do this for every
publication/subscription I create.
AHIA,
Larry....
