navision objects

dsatria

Does Navision (SQL) also store its objects (reports, codeunits, etc) inside SQL database?
We're asking this because we plan to change backup method from "run Navision Backup menu manually" to "using SQL Database Maintenence Plan" and need to be sure that everything is included in the backup.

kriki

Yes, there is a table that contains the objects as BLOB.
When using SQL-backups keep in mind a few things:
-The backup does not the checks the Navision-backup does.
-If you use transaction-log backups, the BLOB-fields will not be backed up. Meaning pictures and the objects itself will not be backed up.

Waldo

Well, it's definitally a progress, because 'when running navision backup', you won't do it every hour ... while in SQL Server you can run a transaction log backup each hour, which give you the chance to go back (for data, no blobs) until maximum one hour before a db crash ...

Do a full backup every day, and you'll have your blobs backed up as before... .

DenSter

Depending on the extent of your development (in which case you should have new and updated object files on the network), you could do all of your necessary backing up through a SQL Server maintenance plan, and only do a Navision backup once every day or even once a week. A SQL Server backup will give you everything you need to run the Navision database.

dsatria

Thank you everyone for your input!

Now we know things to watch over while performing backup testing.