Hi,
have you ever tried to skip the error in the replication monitor?
If you are on the server with an "sa" account, you should start the replication monitor and...

Hi,
I think, it is possible to add an article, without creating a new snappshot with all alrticle. If you lock for these parameters, it is possible, to create a ...

Hi,
if you just want to replicate the newer data, you can create and work with this kind of "filter":
https://msdn.microsoft.com/en-us/library/ms151775.aspx
If you have synchronized your data, you can...

Hi,

are you using a singel instance, or a part of a cluster?

Andreas

Hi,

had you tried to count the IO, when the query runs:

https://msdn.microsoft.com/en-us/library/ms184361.aspx

And what about the execution plan, can you see something interesting inside?

Regards,

Andreas

Hi,

could you check, if your article were stored on the distributor?

Every article should stored in the snapshot-folder.

And can you execute this query on the publication-database:

"sp_helppublication"

And, have you checked, when the...

Hi,

it is not nessesary to break replication, only to add a new articel.

Please watch this link: http://saveadba.blogspot.de/2011/08/adding-new-article-without-generating.html

We use this once a week.

Regards,

Andreas

Hi,

yes, I have a test environment.

Kind regards,

Andreas

Hi,

are you sure, that you, ore the used service account, had all rights. We have a special user called SQLREPL, who had db_owner rights on the publisher, and subscriber database....

Hi,

what kind of replication do you use?

And, if you use transactional replication, do you use push or pull. It is very difficult to tell you, how to start replecation, if...

Hi,

you can script your job to a new one:

-> Right click on the existing job

-> Script Job as

-> CREATE To

-> Agent Job

Now you are able to edit the new job.

Kind...