How to do Incremental FIMS Database Backups
- 17 Jan 2023
- Contributors
- Print
- DarkLight
- PDF
How to do Incremental FIMS Database Backups
- Updated on 17 Jan 2023
- Contributors
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
I would like to do incremental FIMS database backups in addition to full, how can I do that?
Answer:
Prerequisites:
1. Set up a scheduled task to do full database backups first. There must be a full daily backup done to be able to use incrementals.
What is the Recommended Backup Process for the FIMS Database?
2. Set up a scheduled task to do incremental backups:
Notes:
Add arguments: c:\npo\found\dbfiles\found c:\npo\found\dbbackup found.bkp c:\npo\dlc
c. After you've created the scheduled task, you can test it by right clicking in the task scheduler and clicking "run" or select the task and click "run" in the Right-hand Actions list. You can verify that the task is running correctly by checking the npo\found\dbbackup folder to see if your file was created.
The incremental backup file that is created in the dbbackup folder will show a number in the name that represents the time it ran.
Here is an example of a full database backup task and then the incremental task below it.
Here you can see a full and incremental backup files that were created from the scheduled tasks. The file called 'foundbackup.bkp' is the full one and the 'found.bkp-10' is the incremental one that took place in the 10:00 hour and thus has a 10 in the title. Each time an incremental task is run the resulting file will have the hour # in the name of the file.
Notes:
3. In case of database failure and you need to restore your database; how to restore the database in case of failure using a full and incremental backup:
NOTES:
Full backup done every night at 9:00 PM
Incrementals done every day at 10:00 AM, 1:00 PM and 5:00 PM
To restore in this scenario:
- Make sure your database server has sufficient disk space to allow for backup creation.
- Database needs to be running for these tasks to occur.
1. Set up a scheduled task to do full database backups first. There must be a full daily backup done to be able to use incrementals.
What is the Recommended Backup Process for the FIMS Database?
2. Set up a scheduled task to do incremental backups:
Notes:
- You can schedule incremental backups multiple times a day but no more than once an hour.
- What is an incremental backup? An incremental backup backs up only the data that has changed since the last full or incremental backup.
How to setup a scheduled task for incremental backups:
a. In Task Scheduler, create a task by clicking Create Basic Task or Create Task on the right side under actions
b. Configure the settings in the task
a. In Task Scheduler, create a task by clicking Create Basic Task or Create Task on the right side under actions
b. Configure the settings in the task
- General Tab: Check "Run whether user is logged in or not" and "Run with highest privileges.", Give the task a name. The name below is just an example.
- Triggers Tab: Click the New button, in the New Trigger window click "Daily", choose the time to run the task and also choose to stop the task if it runs more than for example, 2 hours. It should take less than that to run the task.
- Click OK and create a new Trigger for each time you want the incremental to run. The schedule below is just an example:
- Actions Tab: Click the New button, chose action 'start a program'
- Program/Script Field: browse to the directory NPO\found\fims\ and choose the file 'dbIncBackup.bat'.
> This file will be released in FIMS 14.75, you can get the file now; it is attached to this article. Copy the attached file to NPO\found\fims and then you can select it to use in the scheduled task for incremental backups.
- Add arguments: add the following arguments separated by single spaces:. This example is for a server where the NPO drive is on C, your server may have NPO on a different drive:
Add arguments: c:\npo\found\dbfiles\found c:\npo\found\dbbackup found.bkp c:\npo\dlc
Start in: c:\npo\found\fims
- Settings Tab: ensure the "Allow task to be run on demand" is checked. You may want to adjust the 'stop the task if it runs longer than..' and the 'if the running task does not end....' areas as well:
c. After you've created the scheduled task, you can test it by right clicking in the task scheduler and clicking "run" or select the task and click "run" in the Right-hand Actions list. You can verify that the task is running correctly by checking the npo\found\dbbackup folder to see if your file was created.
The incremental backup file that is created in the dbbackup folder will show a number in the name that represents the time it ran.
Here is an example of a full database backup task and then the incremental task below it.
Here you can see a full and incremental backup files that were created from the scheduled tasks. The file called 'foundbackup.bkp' is the full one and the 'found.bkp-10' is the incremental one that took place in the 10:00 hour and thus has a 10 in the title. Each time an incremental task is run the resulting file will have the hour # in the name of the file.
Notes:
- It is HIGHLY recommended that you copy the dbbackup folder off to a different location in case the NPO drive or the entire server crashes.
- The incremental found.bkp file that is created in the dbbackup folder will be overwritten each time the task is run. If you would like to keep previous incremental backups, you can rename the backup file that was created so that it does not get overwritten the next time the task runs.
3. In case of database failure and you need to restore your database; how to restore the database in case of failure using a full and incremental backup:
NOTES:
- There must be a full daily backup in order to restore an incremental.
- To restore, you would first restore the last full backup and then the incremental backups in order.
Full backup done every night at 9:00 PM
Incrementals done every day at 10:00 AM, 1:00 PM and 5:00 PM
To restore in this scenario:
- Restore the full backup that was done at 9:00 PM
- Restore the incremental that was done at 10:00 AM
- Restore the incremental that was done at 1:00 PM
- Restore Incremental that was done at 5:00 PM
Attachment:
dbIncBackupWas this article helpful?
