Thank you Jason,

How much should one worry that the Distributor be the same as the Publisher?

The source data is being used by an application but there are not resources...

There has not been an impact with the above port configuration.

I'm looking to setup database mirroring with replication.

Database mirroring is already setup.

Is it possible for a server to act as a distributor and witness?

Principal Server A is syncing...

Thank you that has helped with my research.

As of right now I do not have a remote distributor and or witness server meaning the principal server would have to...

Excellent. Will delve deeper into transactional replication.

I do have the database being mirrored where those table deltas need to be copied.

Should I replicate from the partner database or from the...

The command is not being ran with TABLOCK.

It was successful running up against other databases and also this specific database.

Failed for the first time when I setup log shipping...

This is invaluable information guys much appreciated.

The databases on the secondary server to not have to be in a read state but requirements could change of course.

So changing the timeout...

Thanks guys for the advice.

Jonathan

Thanks guys ...

This is much appreciated how would I go about visualizing this type of query for next time.

Is this a recursive query. Any suggestions knowing what to write depending on the...

There can be multiple fileids yes with different values that are associated with a boxid.

Table B

fieldid Boxid

1 4

2 ...

I have tried that query and it does return a fileid that is in the TableB but not in TableC.

Say there are like 21 entries of a fileid in TableB...

My apologies if I was not clear but I meant on the mirrored databases I could not change the ownership.

Jonathan

Excellent information and guidance definitely helps clarify.

I just purchased that book to gather more information about mirroring.

thanks,

Jonathan

I see that's right. Since the mirror gets written to first then I would not have to worry about data loss.

So the only real disaster scenario with High Safety...