Snapshot Agent Failure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Snapshot Agent Failure

27 posts, Page 1 of 3

1 2 3 »»»

Snapshot Agent Failure

Rate Topic

Display Mode

Topic Options

Author

Message

deepzzzz

Posted Tuesday, December 08, 2009 4:55 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 4:23 AM
Points: 876, Visits: 253

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

Post #830547

steveb.

Posted Tuesday, December 08, 2009 5:27 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 2,802, Visits: 7,107

This could be an issue with the snapshot folder, does the agent have the correct permissions to use this folder?

Post #830557

deepzzzz

Posted Tuesday, December 08, 2009 5:49 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 4:23 AM
Points: 876, Visits: 253

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

Post #830574

deepzzzz

Posted Tuesday, December 08, 2009 5:51 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 4:23 AM
Points: 876, Visits: 253

Could you please tell me how to check whether the agent has the correct right to the folder

Thanks

Post #830575

steveb.

Posted Tuesday, December 08, 2009 5:56 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 2,802, Visits: 7,107

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.

Post #830579

deepzzzz

Posted Tuesday, December 08, 2009 6:31 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 4:23 AM
Points: 876, Visits: 253

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

Post #830600

steveb.

Posted Tuesday, December 08, 2009 6:39 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 2,802, Visits: 7,107

Can you see the files being created in the snapshot folder?

Post #830607

Bru Medishetty

Posted Tuesday, December 08, 2009 6:44 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735, Visits: 1,947

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

Post #830610

deepzzzz

Posted Tuesday, December 08, 2009 6:59 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 4:23 AM
Points: 876, Visits: 253

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

Post #830628

steveb.

Posted Tuesday, December 08, 2009 7:02 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 10:07 AM
Points: 2,802, Visits: 7,107

What sort of replication are you running, push or pull?

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

Post #830633

« Prev Topic | Next Topic »

27 posts, Page 1 of 3

1 2 3 »»»

Permissions