Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    1

    Unanswered: SQL Server 2000 Dynamic Snapshot Error

    Hello

    I am using SQL Server 2000, For Merge Replication.

    While Creating the Dynamic Snapshot, for a publisher having filtered rows, the snapshot agent is returning the status as failed, "The Agent is suspect. No response within the last 10 minutes".

    I then increased the time in Refresh setting to 30 mins, and tried to run the job again, but i am again facing the similiar problem, it is failing again, and the error message is changed the time to 30 minutes.

    Can anyone please help me out, as what else do i need to change, so that i dont get this error.

    Thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    Hi

    Is the DB in use when your trying to create the Snapshot ?

    You could have a Locking problem.

    Try using Enterprise Mgr to look @ the current Locks during the Snapshot generation

    GW
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •