SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Snapshot Agent Failure


Snapshot Agent Failure

Author
Message
deepzzzz
deepzzzz
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1410 Visits: 262
Hi,

We have created a snapshot replication from SQL 2005 to SQL 2000. After configuring the publisher, when I checked the snapshot agent status am able to see that it is not run. It is throwing the error "The system cannot find the path specified". In replication monitor it is showing the error number as 14151.

I have found many articles on the same. But nowhere giving a solution.
Please help me to solve this issue.

Thanks in Advance...

Thanks
steveb.
steveb.
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13670 Visits: 7195
This could be an issue with the snapshot folder, does the agent have the correct permissions to use this folder?
deepzzzz
deepzzzz
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1410 Visits: 262
I have run the snapshot.exe in COM folder from command prompt. Then it is giving the below error.

System.TypeInitializationException: The type initializer for
'Microsoft.SqlServer.Replication.StringResources' threw an exception. ---> System.ApplicationException: The native replication resource dll failed to load.

at Microsoft.SqlServer.Replication.NativeResourceStringLoader..ctor()

at Microsoft.SqlServer.Replication.StringResources..cctor()

--- End of inner exception stack trace ---

at Microsoft.SqlServer.Replication.ReplMessage..ctor(Exception e)

at Microsoft.SqlServer.Replication.HistoryMessage..ctor(Exception e)

at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.SnapshotGeneration

AgentMessageFactory.CreateAgentMessage(Exception e)

at Microsoft.SqlServer.Replication.AgentCore.LogMessage(Exception e)

at Microsoft.SqlServer.Replication.AgentCore.ThreadFailedHandler(Exception e)


The type initializer for 'Microsoft.SqlServer.Replication.StringResources' threw an exception.

Thanks
deepzzzz
deepzzzz
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1410 Visits: 262
Could you please tell me how to check whether the agent has the correct right to the folder

Thanks
steveb.
steveb.
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13670 Visits: 7195
On the folder that you selected to put the snapshots check the permissions, The account that the Agent is running should have permission to the folder.

Also if you check the Agent history you should be able to get a more verbose error message.
deepzzzz
deepzzzz
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1410 Visits: 262
In Sql server agent log also it is not updating anything. The folder have the full control permission for the user account which is used for SQL Agent to run

Thanks
steveb.
steveb.
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13670 Visits: 7195
Can you see the files being created in the snapshot folder?
Bru Medishetty
Bru Medishetty
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: General Forum Members
Points: 7176 Visits: 1950
Where is the directory your snapshot is storing the data.

If it is a network location, verify and see that you have correct path name.


Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
deepzzzz
deepzzzz
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1410 Visits: 262
The snapshot folder does not contain any files. The location of the folder is D:\Program Files\Microsoft SQL Server\MSSQL\90\MSSQL.1\MSSQL\repldata

Thanks
steveb.
steveb.
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13670 Visits: 7195
What sort of replication are you running, push or pull?

are you running a remote ditributor and if so can this access the folder?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search