Post reply

replication connections dont stop

  • February 9, 2004 at 3:58 pm

    #84152

    Hi guys

    I am new to replication and i am encountering a small problem.

    i set up a database for replication.i created publisher,subscriber etc., to acuainte myself with replication.

    finally i deleted all replication related things i mean publisher,subscriber etc.,

    but whats happening is i found 2 connections running background always.when i opened profiler i found this.

    following i copied from a trace

    SQL:BatchCompleted EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters SQLAgent - Alert Engine  rk 20 119 0 20 1140 53 2004-02-10 11:52:02.853 

    i even tried kill those connections but still they come up.

    how do i stop those connections permanantly.

    thank you very much for ur ideas

    cheers

     

     

  • February 9, 2004 at 4:21 pm

    #493310

    What makes you thnk that this has anyting to do with Replication?

    Can you tell me how you dropped replication?

    Kindest Regards,

  • February 9, 2004 at 4:28 pm

    #493311

    -----------------------------

    What makes you thnk that this has anyting to do with Replication?

    -------------------------------

    bcoz from profiler i found that connection related to replication.it executes following proc all the time

    EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

    and shows login name rk bcoz while creating replication i used rk (i.e my login) instead of sa

    ----------------------

    Can you tell me how you dropped replication?

    ----------------------

    i just selected publisher and deleted from context

    menu.

  • February 9, 2004 at 6:11 pm

    #493316

    The correct process to remove Replication is....

    (A) Drop Subscriptions

    (B) Drop Publications

    (C) Disable the Publishing Database

    Did you do it in this order?

    Kindest Regards,

  • February 9, 2004 at 6:21 pm

    #493318

    Thanks for ur reply.

    actually i dont remember the sequence

    but i still see the Hand icon on database name which i used for replication.

     

  • February 9, 2004 at 11:04 pm

    #493329

    You need to disable that Database as been Published!

    Kindest Regards,

  • February 10, 2004 at 12:48 pm

    #493473

    Thanks for ur reply friend

    But i dont see any option to disable the database.

    cheers

    rajani

  • February 10, 2004 at 12:54 pm

    #493476

    hi friend

    I think i did it.

    i selected publisher folder and in the context menu there is an option disable current server as

    distributor.i removed that check and finally i dont

    see hand icon on my database.

    But i still see those 2 connection in profiler running all the time.i see following 2 events running all the time .i dont understand what they are ?

    SQL:BatchCompleted SELECT N'Testing Connection...' SQLAgent - Alert Engine  rk 0 0 0 0 1140 53 2004-02-11 08:49:38.963 

    SQL:BatchCompleted EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters SQLAgent - Alert Engine  rk 20 122 0 80 1140 53 2004-02-11 08:50:19.093 

  • February 10, 2004 at 5:06 pm

    #493525

    Ok.....You are learning a bit more about SQL Server Replication! In future you should study up on it before installing, configuring and removing SQL Server Replication as it is a huge topic!

    Now......Those connections you are seeing are Replication Jobs! If you go to your Jobs Folder you will probably see 2 Jobs that were a part of Replication!

    DO NOT DELETE those Jobs but Rather, I want you to tell me what the names of those Jobs are and what the Jobs are actuaslly doing before you go ahead and DELETE those Jobs.

    Do that and get back to me!

    Kindest Regards,

  • February 10, 2004 at 5:22 pm

    #493531

    i have 4 jobs running.but all of them are owned by

    user sa .there is no single job by user rk

  • February 10, 2004 at 8:45 pm

    #493543

    What are those 4 jobs? What do they do?

    Kindest Regards,

  • February 10, 2004 at 8:58 pm

    #493546

    Hi friend

    i just found out whats happening here.

    in the sql server agent properties window there is an option

    (in connection tab)

    sysadmin loginid entered as rk

    thats why those connection using user account RK.

    sql server agent using that account to moniter sql server

    oh!god finally i got some relief.

    cheers  

    Rajani

  • February 15, 2004 at 5:39 pm

    #494120

    I think what you're seeing is the auto refresh in Enterprise Manager that updates your replication status. If you right click there is an option not to auto refresh, see if that helps.

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • February 15, 2004 at 5:44 pm

    #494122

    Thanks for the reply Andy

    i could not find auto refresh option.

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply