"sqldba" <sqldba@abc.com> wrote in message
news:aa425e98b7ce4ca191e6474883977d46@ureader.com...
>I need your help & suggestion to correct my approach/Option.
> couple of days back i ran in to Replication Error. So i dropped &
> re-created
> my Subscription with no-sync. after running Application Reports, reports
> were not accurate. so keep customer happy i decided this 2 options. i need
> your help, whether i should do this or take another option to resolve the
> issue. when i did re-snapshot i ran into " Violation of primary key"
> Error.
> so i dropped & recreated my Subscription with no-sync and it is working
> fine
> from last 24 hours with no errors. so what i am trying to achieve is to
> fix
> this discrepancy problem that i see in my App reports. as i know this
> problem is due to pending Transaction that didn't relicated to Subscriber.
> OPTION 1:-
> 1> Stop Agents
> 2> Drop the scription
> 3> Drop the Subcriber Database
> 4> Re-Create the Subscription with new Database
> 5> Start the Agents
> 6> Stop & start the SQL AGENTS SERVICE
>
> OPTION 2:-
> 1> Stop the Agents
> 2> Backup the Database from Server A & restore to
> Subcriber Server.
> 3> Start the Agents (Log Reader & Distribution)
>
> please advise me the which options is good or my option are totaly wrong &
> let me know the best practice & approach.
>
> Any help will be highly appreciated.