file_backup

Perform a file backup for a persistent database.

For an overview see page File_Backup

Prototype

     
    file_backup( dbFile, logFile, nThreads);
     

Arguments

dbFile The path and filename for the backup database file
logFile The path and filename for the backup log file
nThreads The number of threads to perform the file copy operation

Description

This function allows applications to copy the database and log file for a persistent database. The database can then be "restored" by simply specifying these backup files and opening the database in the normal way. File backup can be the most efficient way of creating a backup of a disk database because it copies data at the file level, sequentially, without interpreting the content of the pages. Please see the File Backup page for further details. (See also C++ method fileBackup().)

Example

 
    SELECT file_backup("SimpleDb_backup.dbs", "SimpleDb_backup.log", 1)
 

Note that if this select statement is executed by a remote client, the file names refer to the server's file system.