Plataan - Microsoft Dynamics - Learning & Competence Management Vincent Bellefroid Koen Stox Steven Renders Conny Schuddinck Steffie Alexiou
A blog about Microsoft Dynamics
Home Archives Subscribe Plataan website

« An interesting blog about Business Intelligence. | Main | Choosing the Recovery Model for a Database. »


‘Big’ Backups in Dynamics NAV

When using the Dynamics NAV client to create a backup of a database, you might get into the situation that the backup (.fbk) file that you are creating exceeds 2Gb of data.

Well, in fact this will never happen, because as soon as the .fbk file reaches 2Gb, Dynamics NAV will create an extra .fbk file and continue in that one, until it also reaches 2Gb and then it will create a third file, and so on…

Sometimes this behavior might give an issue

The name of the extra backup files will contain a number. If you named the backup file backup1.fbk, then the second backup file will be named: backup2.fbk.

The problem occurs when you did not put a number in the name of the backup file AND the path of the folder in which you are storing the backup contains a number. Dynamics NAV will take the name and path of the backup file as a string, and will start searching from right to left for a number to increment. If one is not found then 1 will be added as the number.

So you might get into the situation that you are creating a backup named fin.fbk in a folder called: c:\temp1\fin.fbk. As soon as this backup file becomes greater then 2Gb, Dynamics NAV will try to create an extra backup file like this: c:\temp2\fin.fbk and if the folder c:\temp2 does not exist, an error will occur.

So think about this when you are creating a backup (.fbk) from a big Dynamics NAV database.


The comments to this entry are closed.

October 2011

Mon Tue Wed Thu Fri Sat Sun
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30

Plataan Community

Visit us on LinkedIn Visit us on Facebook Visit us on Twitter