MSDE and transaction logging with Navision

orbitalsalmon

Hi everyone,

We're going to be running Navision Attain 3.70 on Win2k3 using the default MSDE it comes with (not MSSQL server). I've recently heard that MSDE is prone to corrupted index pointers if there's a power glitch. We have a pretty reliable APC smartups, but a consultant recommended turning on transactional logging with MSDE in order to fully restore data if we lose it. Now, I have absolutely no idea how to set this up or if it's even common practice. Does anyone know?

thanks in advance.

dmccrae

I am surprised you are running MSDE as a production sever at all - its not the intention of it, although it is possible.

Go into File/Database/Alter in Navision and set the Recovery Model Option to 'Full'.

You can then perform transaction log backups from Enterprise Manager (or Query Analyzer etc). Look in Books Online for info on making transaction log backups. These backups can be restored against a database to restore only those transactions completed in that backup - instead of having to do frequent full database backup/restores.