Post reply

How to verify replication on the subscriber SQL 2005

  • March 21, 2011 at 9:07 am

    #150060

    Hi,

    I am trying verify that replication is on and current on SQL 2005. My server is the subscriber and I dont have access to the publisher. In management studio under replication -> local subscriptions when I right click on the subscriber's name and click 'view synch status' that action is attempting to connect to the publisher and its failing cuz I dont have access. All I need it to verify that I am active either through t-sql or ssms.

    Thanks

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • March 21, 2011 at 9:58 am

    #1301386

    Use Performance Monitor on subscriber server and select all Sql Server Replication counters.

    Alex S

  • March 21, 2011 at 10:16 am

    #1301396

    Do a Sample update on a non critical table\article on the publisher by

    updating column with. and check on the subscriber if it is current and roll back to original later on.

    Thanks,

    Naveen

  • March 21, 2011 at 10:25 am

    #1301403

    Let me know if i am not clear?

  • March 21, 2011 at 10:44 am

    #1301418

    You could run a trace looking for activity coming from the publisher server / database. Typically, your distribution agent is going to be named PubServer_PubDB_ . You can query sysprocesses on that to ensure that it is running. Then start up a trace with that application name and watch for changes.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • March 21, 2011 at 4:24 pm

    #1301633

    David Benoit (3/21/2011)

    You could run a trace looking for activity coming from the publisher server / database. Typically, your distribution agent is going to be named PubServer_PubDB_ . You can query sysprocesses on that to ensure that it is running. Then start up a trace with that application name and watch for changes.

    I ran a trace and there are activities from the publisher. Thanks to all of you for your inputs - appreciated.

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • March 21, 2011 at 8:01 pm

    #1301657

    Glad that worked for you. 😀

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 7 posts - 1 through 6 (of 6 total)

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