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


Snapshot Agent Failure


Snapshot Agent Failure

Author
Message
deepzzzz
deepzzzz
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1856 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.
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

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

Group: General Forum Members
Points: 1856 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
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

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

Thanks
steveb.
steveb.
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23120 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
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1856 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.
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

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

Group: General Forum Members
Points: 11962 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
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1856 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.
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23120 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