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

log reader agent stuck in 'retrying' Expand / Collapse
Author
Message
Posted Saturday, September 22, 2012 8:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 01, 2012 1:15 PM
Points: 7, Visits: 20
trying to set up a simple publication on sql server 2000 (Microsoft SQL Server 2000 - 8.00.2039)

My SQL Agent is running using an NT authenticated account that is an administrator on the server. I created a new Publication of 2 tables - set it up as transactional replication - continuous log reading. I basically took all of the defaults in the wizard.

The log reader job starts - then bounces from starting to retrying for 15 mins or so before failing.

I do not see any errors in the sql server or replication log. The only error I can find is in the application event log for the job itself: SubSystem Message - Job 'TestDB-TestDB-8' (0x64C7317E150D984198AA5473511F6558), step 2 - Server execution failed

can anyone help????
Post #1363108
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse