It sounds like there is some metadata remaining in your database which needs cleaning up.

You can try these.

sp_dropsubscription and sp_subscription_cleanup. If these arent working for you, you will likely...

We build all of our indexes online with the sort_in_tempdb option. This helps somewhat with contention on our busiest production servers.

From experience, adding tables to a publication through the GUI is a bad idea. IT can trigger a force_reinitialisation.

Use sp_addarticle. You will also need to re-add any subscriptions...

I should also point out, that you can get around the full snapshot by adding the subscription to the new subscriber a @syncronisation_type (?) = 'none' and restoring a full...

You only need to do it when you have made changes to the publication. Any other time is redundant.

If you've made changes to the publication correctly by script, the...

Based on this error you are either applying a snapshot or replicating a ddl change.

Basically the foreign key already exists at the subscriber and for some reason the if object_id...

You generally wont need to do anything too drastic. this is what I would do.

1. Confim the status of each subscriber in Replication monitor. Be careful not to...

One thing I may not have mentioned. If you are updating rows using a stored proc, including the sp in the publication will allow replication to depliver a single...

As it is taking so long, it suggests there are several million undelivered transactions. This is normally due to an unreachable subscriber or an error preventing deliverly.

If...

This would appear to be easier than the previous replies suggest since you have an existing database instance on a cluster.

1. Are you able to/allowed to host the this database...

Have you checked the space used? If there is plenty of empty space there is no reason why you cannot shrink the database to a more reasonable size. ...

Switch it to offline and see who shouts? 🙂

You "could" use a third party tool.

Apexsql Diff can create Database object snapshots. You apply the replication snapshot then use apexsql diff to compare the created Apex snapshot to...

I dont use the GUI much so I hadnt really noticed.

I'm not sure I follow you. Are you talking about the max memory setting in SQL Server, the physical memory registered in windows, the amount of memory used by...