Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The replication agent encountered an error and is set to restart within the job step retry interval. See the previous step history message or replication... Expand / Collapse
Author
Message
Posted Wednesday, December 26, 2012 7:27 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 2, 2013 9:54 PM
Points: 24, Visits: 88
Hi,

Im new with SQL, please help me on how to trouble shoot this error

"The replication agent encountered an error and is set to restart within the job step retry interval. See the previous step history message or replication monitor for more information"

Im using SQL server 2005.

Fatin
Post #1400430
Posted Wednesday, December 26, 2012 10:11 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 6, 2014 8:19 PM
Points: 121, Visits: 1,251
You need to enable your agents for logging and see what error is logged.

Use this kb article to see what the failure is.
When the agent fails you may also want to run profiler to see what is causing the problem.

http://support.microsoft.com/kb/312292


SQL Database Recovery Expert
Post #1400452
Posted Thursday, December 27, 2012 1:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 2, 2013 9:54 PM
Points: 24, Visits: 88
Thanks.

I found that there's not enough space for the replication.
Post #1400492
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse