Read this before making further decisions.

http://blogs.msdn.com/b/psssql/archive/2008/09/12/sql-server-2000-2005-2008-recovery-rollback-taking-longer-than-expected.aspx

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...

At a minimum, when SQL Server is the only application running on the server, I will at least leave 2 GB for the OS and any odd processes, etc. With...

I typically force escalation on replication issues due to some of what you describe. I'll leave it at that.

Glad you got it fixed.

TheLazyWriter (3/11/2011)

---

You can add fields to a table which is an article and part of a transactional publication, and the field will be applied to the subscriber. I don't think...

Yes, any reference to that database will have to be changed to the new name; whether in SSIS, query, connection string, etc. Best to log all connections to that database...

Agree with danT, you should be profiling to find the high read / write queries. Pick a number, say 20,000 reads, and use that as your filter. Find the queries...

Krasavita (3/11/2011)

---

Guys, I just checked the schema and data was replicated to the other table, but they don't see it on the webside, so I think this is not replication...

Krasavita - sounds like you should be ok going with MysteryJimbo's recommendation then and that will allow you to avoid the new publication.

Let us know how that goes.

MysteryJimbo (3/11/2011)

---

David Benoit (3/11/2011)[hr

Correct me if I am wrong but I thought that this was ONLY true when immediate_sync was not set on and if it was it would generate...

256 GB

MysteryJimbo (3/11/2011)

---

Altering a replicated tables structure DOES NOT require a full reinitialisation of all subscribers. Imagine doing this when a publication contained many gigabytes.

Ensure you do this in TSQL....

There is a way (which I have not tested yet - due to though) to put a table in the same publication and only force the snapshot for that table....

Validate is only going to look for data consistency - http://msdn.microsoft.com/en-us/library/ms151251.aspx.

If you can reinitialize all the subscriptions then do the first set of steps that I recommended and that...

Krasavita (3/10/2011)

---

I am not ok, I have to find out from management, I am new here:

I do't have access to that server (subscriber)and I don't think it is a good...