Viewing 15 posts - 31 through 45 (of 195 total)
" 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...
July 2, 2009 at 10:54 am
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...
July 2, 2009 at 10:46 am
rupesh.net (6/25/2009)
June 26, 2009 at 8:23 am
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...
June 26, 2009 at 8:06 am
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...
June 25, 2009 at 9:35 am
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)
June 25, 2009 at 9:26 am
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?
June 25, 2009 at 9:18 am
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...
June 25, 2009 at 9:16 am
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...
June 25, 2009 at 9:04 am
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...
June 25, 2009 at 8:56 am
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...
May 21, 2009 at 9:19 am
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...
April 13, 2009 at 8:28 am
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...
March 30, 2009 at 1:50 pm
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...
March 30, 2009 at 10:03 am
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...
March 30, 2009 at 9:16 am
Viewing 15 posts - 31 through 45 (of 195 total)