backup > 2gb

[daniyagui]

Hi:
I'm new in SqlBase 7.5.1.
What have to do for backup a .dbs base of 2.5 gb?

Regards

 

[PlsHlpKat]

You will need to do Segmented Backups/Restores of a SQLBase Database

SQLBase 7.5.x removes the 2GB limit for SQLBase databases installed on an NT server - that's the good news.
The bad news is that the 2GB limit remains for backup files that exceed the 2GB limit.

To perform a segmented backup you first need to create a Backup Control File (BCF).
The BCF is a text file that contains three bits of information for SQLBase
1. The FILEPREFIX statement, which designates the backup, segments file name.
2. The DIR statement, which designates the destination directory for the backup segments.
3. The SIZE statement, which designates the maximum size for each segment (up to 2GB per segment).

For example (where VMFG is the name of the database to be backed up):

FILEPREFIX VMFG

DIR C:\TEMP SIZE 500
DIR C:\TEMP SIZE 500
DIR C:\TEMP SIZE 500
DIR C:\TEMP SIZE 500
DIR C:\TEMP SIZE 500
DIR C:\TEMP SIZE 500

Then save the file (text only) as VMFG.bcf

I have full a detailed instruction document I can e-mail you if you like. Just le me know.

 

[daniyagui]

Thanks so much!!

If you want send me the document please. Thank you again!