260
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
Hi Colinkgl,
Basically, NAV native database (FDB file) includes 3 parts:
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:
Hope it can help you!
I am 100% agree with Jens. You should use this method to take backup as required.
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
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
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
Yes. FDB and FBK backup includes all your customization and data also.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (