Navision 5.01 Redundancy

jongs

Hi there

Im Currently Running Nav 5.01 on Sql 2008 and im curious about failover options (Mirroring) many peeps talk about this option as no go couse Navioson data could have some timestamp errors.. could u guys advice me on this issue.. what are my options with 5.01.. should I consider updating my clients to gain more options ?

Best Regards
Jón G

Alex_Chow

jongs wrote:

Hi there

Im Currently Running Nav 5.01 on Sql 2008 and im curious about failover options (Mirroring) many peeps talk about this option as no go couse Navioson data could have some timestamp errors.. could u guys advice me on this issue.. what are my options with 5.01.. should I consider updating my clients to gain more options ?

Best Regards
Jón G

What you're talking about has nothing to do with the version of Navision you're using.

jongs

ok thx for the reply but could u then confirm that Db Mirroring with Navision is an Option..

bbrown

We have a client that's been using database mirroring (high availability mode) for 4 years or so. Works just fine. That's not to say it's the only or best option. You have to evaluate your needs and choose the best option(s) for you.

jongs

Thx m8 for the info

Alex_Chow

jongs wrote:

ok thx for the reply but could u then confirm that Db Mirroring with Navision is an Option..

Any software with any fail over plan is an option. This is not a Navision specific question.

jongs

Well I was told that Navision Could not work in mirroring couse of timestamp issues, well at least that what our local Navision support told me.. log shipping was something they recomended.

bbrown

jongs wrote:

Well I was told that Navision Could not work in mirroring couse of timestamp issues, well at least that what our local Navision support told me.. log shipping was something they recomended.

Mirroring does not rely on timestamps. Possibly they are confusing it with transaction replication? I can tell you mirroring works just fine.

Log Shipping is also another valid solutions. Both these have pros and cons. You need to review your situation and pick what's appropriate. Sometimes that's to do both.

Alex_Chow

mirroring is failover. log shipping is for DB restore. You and your local NAV support person are talking about different things.

bbrown

I'd disagree with that. Mirroring and Log Shipping are both for fail-over. One's just more automated than the other.