Forum Replies Created

Viewing 15 posts - 31 through 45 (of 196 total)

  • RE: transactional replication

    " The row was not found at the Subscriber when applying the replicated command"

    This means exactly what the error message says. You have two options.

    Option 1: If you don't...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: transactional replication

    Agent history clean up: distribution

    Default schedule is daily, every 10 minutes.

    AJAYG-cicenrich-1

    This is your queue reader agent job. It doesn't really matter for traditional transactional replication. By default it's set to...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: Restart Replication

    rupesh.net (6/25/2009)


    This is really very good to see all of your views and that is correct by identifying the failure reason we can restart the replication agent. I would love...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: Publisher bathing in syrup

    One difference that you'll see in the transaction logs with replication in play is that transactions are retained in the log until the log reader agent has picked up the...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: Configure Distribution

    Couple of questions:

    - What version ad edition of SQL Server is installed? (e.g. 2005 standard)

    - Where the replication components installed during the SQL install?

    - What value do you get for...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: Changing Distributor

    Try this:

    sp_dropdistributor @no_checks=1,@ignore_distributor=1

    (Read more on the SP here: http://msdn.microsoft.com/en-us/library/ms173516(SQL.90).aspx)

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: Publisher bathing in syrup

    What recovery model was the DB in before you started replicating? And do your transaction logs sit on dedicated drives or are they on shared drives with your data files?

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: In a snapshot replication, users will be able to connect to the replica while replication is running?

    Users can connect to Server B but will not be able to select from whatever table the snapshot agent is currently working on since it will be locked by the...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: Restart Replication

    There are many scenarios where a distribution agent can fail and how you handle it depends on the severity of the failure.

    - If it's a failure because a row is...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: transaction replication

    Do you want to disable replication of all deletes all the time, or are you trying to selectively disable deletes at particular times while allowing deletes to be replecated at...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: Using CLR to do XSLT

    Some more information: The source is essentially verbatim from this blog post: http://blogs.msdn.com/mrorke/archive/2005/06/28/433471.aspx

    So aside from whether or not XSLT should or should not be done in SQL, is there a...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: SAN and potential Filegroup configuration help required....

    If you're stuck with the SAN configuration that you've got then at least consider the following:

    - Assuming your workload is typical OLTP (e.g. 80\20 reads\writes) put your data files onto...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: Changing the key field of a replicated table

    It really all depends of what you call "nothing wrong". The fact that you may need to use replication for failover purposes makes the use of Identity columns a pain...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: error setting up a new subscription

    Make sure that the account you've set your distribution agents to run as has the necessary rights to both the publisher and subscriber. Are the publisher and subscriber in the...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

  • RE: error setting up a new subscription

    That sounds like an issue between your machine and the subscriber. Are you using your desktop\laptop to set up the subscription, and if so can you open a new query...

    Kendal Van Dyke
    http://kendalvandyke.blogspot.com/[/url]

Viewing 15 posts - 31 through 45 (of 196 total)