Problem Replication sql2005/navision 50sp1

Lorenzho · 2010-10-22

Hello,
I'm implementing the replication process between two servers/istance.
The database is Nav5.0sp1.
The connection between two server is unstable.
Some errors occurring during the process to replicate the first snapshop in the server subscription. It's Snapshot Replication method.
i.e: "TCP Provider: The semaphore timeout period has expired."
In to some tables, the Primary keys disappeared in SQL. (i.e Sales Header).
The error occurred during the replication with copy the "object" table.
Have someone the suggestions how to do the replication with nav database without errors?
Thanks in advance,
Lore

kine · 2010-10-23

Replications are dangerous for NAV!

All depends on how you are using them, what you really need, which replications are you using etc.

Replicating Object table is not good thing for me. How you are using the replicated DB? In NAV too?

kriki · 2010-10-25

If you want to have the complete DB replicated, you better check if transactionlog shipping or mirroring (SQL server mirroring!) is better for your case.

bbrown · 2010-10-25

The mirror database is unavailable for use. However you could create database snapshots, from the mirror, and use that for reporting. Database snapshots require SQL Enterprise Edition.

Database Snapshots are read-only so they would not support any reporting that requires writting to the DB.

bbrown · 2010-10-25

With Mirrororing, High Performance Mode would be the only viable choice in your situation. With any solution having a more stable connection would always help. Any oppurtunity to improver that?

Lorenzho · 2010-11-11

Thanks a lot.
I changed the solution. It's not possible to use snapshot for my pourpose.
Lore

bbrown · 2010-11-11

Lorenzho wrote:

Thanks a lot.
I changed the solution. It's not possible to use snapshot for my pourpose.
Lore

What did you change it to?

Howdy, Stranger!

Quick Links

Categories

Problem Replication sql2005/navision 50sp1

Comments