gk-411903 (10/22/2009)

---

Hello Swarndeep

Would you mind telling me where / how to set "Continue on Data Consistency error" option? In Bcp or the Destination agent job; I know of mentioning the...

You might employ scripts that run before and after a snapshot applies. I have never tried this yet, but in the Snapshot Agent properties you can set up scripts...

I had this issue when my @sync_type was set to 'replication support only'. I scripted the old replication which was created without sending a snapshot, so when I reran...

I find that creating the replication scripts REALLY speeds up recreation publications. I do sometimes have to add things like passwords.

actually the problem was that the DML was trying to do a subquery that worked on all of the other subscribers because they had not been updated. It didn't...

Come to find out - one of the subscribers had been updated so that the REPL command would in fact the subquery became invalid returning multiple rows instead of a...

Thank you. That is what I was thinking.

I constantly find myself with questions related to how replication works and what will happen if I do this or that. You are right though after digging around...

I think the issue is that we were trying to install two default instances on one cluster.

Here is a quote a co-worker sent me:

SQL Server depends on distinct...

Yes, I went to advanced install and made sure all of the paths did not have the incorrect drive. It seems to be picking the M: drive up from...

This is SQL 2005. 1 Cluster, 2 Cluster Groups, 2 instances with failover. The issue is that the installer is looking for the wrong Disk Resource....

The Problem that replication really impose is "planning".

If you plan to do a lot of replication related configurations you should:

- Standardize file/Folder locations and CALS

- Save scripts to drop/recreate...

Thanks a TON. You just saved me a ton of work.

I haven't given up, I am just taking some time to read the posts that were given. I'll give an update when I have one.

Steve T: Yes. That's very close to what I need to do. Thank you.

Garadin: I will read that and see if I can apply it to...