August 12, 2008 at 11:26 am
I am attempting to add a new push subscription to a replication set up that has not been touched for ages.
the new subscription created and I requested snapshot run immediately to create data and schema. The snapshot agent faled with message The process could not create file 'g:\SQLData\MSSQL\ReplData\unc'.
where did it get that filepath from , that directory does not exist and is not where we install our databases.
should I just create the folder, or how do i find out folder it should be using and change it or should I manually set up the initial data? (we are not publishing all tables)
Now snapshot has failed if i do run it is it clever enough to know I only want to initialise new subscriber not existing ones.
---------------------------------------------------------------------
August 12, 2008 at 12:16 pm
In the publication property > Snapshot, one would indicate where the generated snapshot should be stored. Change the path over here to a valid one.
Also, View Details ( in replication monitor ) for all the subscriptions for this publication will tell you which ones are waiting for a snapshot. Once you run the snapshot agent, all these subscriptions will start applying the new snapshot.
August 12, 2008 at 2:36 pm
Nikhil, thanks so much for your input, its so good to have a second opinion when under pressure.
I looked at creating a new location, but had doubts about going for an alternate snapshot location, so opted for creating the directory it appeared to want: g:\sqldata\mssql\repldata.
restarted snapshot agent and it created the unc path under above and succeeded
cheers
george
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply