REPOST:Cannot find Snapshot 2005

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...
Larry, you can change the default snapshot location for your publisher from
SSMS by Right-click Replication folder->Distributor Properties->Select the
Publishers page on the left pane->Clink on the ... button for the publisher
you want to change on the right pane->Modify the Default Snapshot Folder
field in the pop-up dialogue box and hit Ok->Hit Ok *again* on the
Distributor Properties dialog box to commit the change. Note that the change
will not be picked up until the next snapshot being generated.
Hope that helps,
-Raymond
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1166644241.462462.124840@.73g2000cwn.googlegro ups.com...
> 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...
>