Cannot find Snapshot - SQL 2005
- From: "LPR-3rd" <lreames@xxxxxxxxx>
- Date: 6 Dec 2006 10:23:03 -0800
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??
AHIA,
Larry...
.
- Follow-Ups:
- Re: Cannot find Snapshot - SQL 2005
- From: Hilary Cotter
- Re: Cannot find Snapshot - SQL 2005
- Prev by Date: Re: SQL Server 2000 merge replication: amending a view
- Next by Date: Replicate from SQL to a file
- Previous by thread: SQL Server 2000 merge replication: amending a view
- Next by thread: Re: Cannot find Snapshot - SQL 2005
- Index(es):
Relevant Pages
|
