Backing up of NAV

(1) Share

Report

Posted on by colinkgl

268

Hi,

My organization uses Dynamic NAV 20009 classic (not the SQL version)
Is it good enough to simply just back up the FDB or FBK file?
Does the FDB or FBK files includes all customization including the FOB files (customized object) etc?

Thank you

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Jatin Patel 2,641 on at

Like (0)

Report

RE: Backing up of NAV

Yes. FDB and FBK backup includes all your customization and data also.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,969 Super User 2025 Season 2 on at

Like (0)

Report

RE: Backing up of NAV

If you want only objects then Select the objects and File-->Export..which will have only objects.

If you need data also use FDB or FBK

Was this reply helpful? Yes No
Suggested answer

Saurabh Shah 4,560 on at

Like (0)

Report

RE: Backing up of NAV

Yes, FDB and FBK both includes objects and data. however FBK file have an option to export only objects without data or export only for selected company with data and objects.

-Saurabh Shah

Was this reply helpful? Yes No
Suggested answer

Jens Glathe 6,092 on at

Like (2)

Report

RE: Backing up of NAV

Hi colinkgl,

one additional hint: the FDB ist the database file (could be more than one file). If it gets corrupted (and the system might not notice for a while) you will backup a corrupted FDB file. Better to create a .fbk backup (if possible) daily and backing up this. Also, you can copy the FDB file only when the server service has been stopped. Otherwise you will get a corrupted copy. For a copy while the service is running, the program "hotcopy.exe" should be used. But this thing is a PITA in itself.

The .fbk file contains everything the runtime needs to restore a database, when a complete backup has been made. It contains all tabledata and all objects. The one exception I have come across is table 2000000006 "Company". If you have additional fields in this table, they won't be restored (at least not when restoring to a SQL database).

Regarding restore times: I have a customer who has a 40GB native database. Restoring the database from .fbk on a current laptop with SSD runs under 1 hour, on a machine with HDD under a day (or so).

with best regards

Jens

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Backing up of NAV

I am 100% agree with Jens. You should use this method to take backup as required.

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report
RE: Backing up of NAV

Hi Colinkgl,

Basically, NAV native database (FDB file) includes 3 parts:

Data per Company (e.g. item, vendor, customer).

Data Common to All Companies (shared to all companies, such as user, permission).

Application Objects (NAV objects are exported to FOB file).

FBK is a NAV native database backup file. Depend on your selection, the backup file can include all customization or not.

For backup database purpose, I prefer to run a scheduled batch file every night:

Stop NAV database service.

Copy FDB file to a distinct physical disk.

Start NAV database service.

Next morning, you should login copied FDB file to check it.

Hope it can help you!

Was this reply helpful? Yes No