2GB limit or did I do something?

yuppicide

I've noticed my FBK backup files are split into two files now.. is it because I did something or is it because of a 2GB filesize limit?

The first file is 2,097,152 and the second is 85,000 roughly and growing.

DenSter

That's because of a 2 GB file size limit. When the FBK goes over 2GB it will split it into multiple files. If your backup is 6 GB in total, the system will cut it into 3 pieces.

Now that you know it is in multiple files, next time you run a backup, make the file name end with the number 1.

matttrax

No, it's just a size limit.

One note, be sure your backups aren't named something like Backup10_01_2009. Otherwise now that it is big enough to require two files, the second file will be Backup10_01_2010 because it just auto-increments it.

yuppicide

I do name them datewise.. like 100109.fbk.. but that's okay that it auto increments it. I only save backups from the past 2 weeks usually and delete the older stuff.

I have them in on my network drive, as well as backed up daily on tape except for weekends.

DenSter

If you name it 100109_1.fbk, the next split files will be named 100109_2.fbk, 100109_3.fbk, etc. That way you always know which one is the first one, which you need to know for when you need to restore the database.

kriki

DenSter wrote:

That's because of a 2 GB file size limit.

That 's an old FAT16 inheritence.

The same limit is for temptables that are so big they are written to disk and also dataports and files written by NAV.