System information

dbmaint_backuplevel: 0=no backups,1=daily,2=daily,monthly,weekly,3=hourly,daily,monthly,weekly,4=keep lots of files
dbmaint_backupdbdir: local path (accessible for the server)
dbmaint_backupdbnetworkdir: path accessible for the database engine (it is necessary when the database is located on a separate box. Otherwise can be left
empty –default to dbmaint_backupdbdir)
3.5.4. Using backup database tables
To keep your active size smaller, you can move the content of big database tables to another database. For example cdr records older than 5 month, etc.
This backup database will be easily accessed by the MManage.
dbmaint_backuptables: backup cdr records and other tables to xxx_backup: 0=no,1=cdrs,2=extended,3=all
Frequently used and important tables are backed up daily, the other monthly.
The amount of data that is backed up can be controlled by the “dbmaint_removecdrs” (measured in days. is direct proportional with this setting)
If the dbmaint_backuptables is set to 2, than the amount of data can be controlled by the dbmaint_removeother value.
Logs are removed after dbmaint_removelogs days.
The backup databases are created with the same name as the current database with a “backup_” prefix.
If you want to place the backup tables to a separate server, you must set that backup server as a linked server in the main database and set the
“linkedserver” config option in the server inifile.
The backup intervals can be controlled by the “dbmaint_backuplevel” option: //0=no
backups,1=daily,2=daily,monthly,weekly,3=hourly,daily,monthly,weekly,4=full,5=keep lots of files
(be aware that if you set it to 0, than the other option will have no effect)
In order to take advantage of the backup database, you must set the “Secondary database” option in MManage to “Autodetect” or “Secondary DB”. When
set to autodetect, it will attempt to load data from the backup database if the query date is set to more than 1 month later (it will failback to main database if
is set to earlier than 2 week). In this case the “until” date is modified automatically to yesterday midnight when needed.
For the MManage to be able to connect to the backup database, the “backupdatabaseaddress” must be set up correctly when a separate database is used.
3.5.5. Database maintenance
The server will optimize the database engine automatically.
dbmaint_do: enable/disable the daily and the monthly maintenance
dbmaint_removelogs: Trunk log tables and remove logfiles after x days