Summary
This article describes the process to backup the InfoBurst repository when the repository type is SQLite.
Repository File
Identify the file name of the SQLite repository:
- Select the ? icon (top right) in the InfoBurst user interface
- See System Information > Repo Database
- Note this file name (example: IBRepo.db) for backup purposes
Manual Backup
A manual backup is recommended before making a server environment change like an InfoBurst or Windows software update.
- Stop the InfoBurst service
- Open the Repository folder located in the InfoBurst application root folder (default = C:\Program Files\InfoSol\InfoBurst)
- Locate and copy the repository file (see Repository File above)
- Paste the file to a backup folder. A backup folder separate from the server is recommended.
Scheduled Backup
A scheduled repository backup can be achieved using a PowerShell script and Windows Task Scheduler.
PowerShell Script
- Download the script file (IBSQLiteRepoBackup.ps1) attached to this article
- Move the file to the Repository folder located in the InfoBurst application root folder (default = C:\Program Files\InfoSol\InfoBurst)
- Open the script file in a text editor
- Update <RepoFile> with the name of the repository file (see Repository File above)
- Update <BackupFolder> to your preferred backup folder. A backup folder separate from the server is recommended.
- Save the script file
Example:
Stop-Service -Name InfoBurst Start-Sleep -Seconds 5 Copy-Item -Path IBRepo.db -Destination E:\Backup Start-Sleep -Seconds 5 Start-Service -Name InfoBurst
Windows Task Scheduler
The PowerShell script is scheduled by a Windows administrator using Windows Task Scheduler. The backup process requires stopping the InfoBurst service which will terminate any executing jobs. We strongly recommend the backup be scheduled at a time when no jobs are running.
- Select Start > Run
- Enter taskschd.msc
- Select Create Basic Task
- Name: InfoBurst Repository Backup
- Trigger: Select a task start (daily or weekly recommended), start date and time
- Action: Select Start a program
- Program/script: Enter C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
- Add arguments (optional): Enter -File "<APPROOT>\Repository\IBSQLiteRepoBackup.ps1"
- Replace <APPROOT> with the path of the InfoBurst application root folder (default = C:\Program Files\InfoSol\InfoBurst)
- Example: -File "C:\Program Files\InfoSol\InfoBurst\Repository\IBSQLiteRepoBackup.ps1"
- Start in (optional): Enter <APPROOT>\Repository
- Example: C:\Program Files\InfoSol\InfoBurst\Repository
- Select Finish
- Open the properties of task InfoBurst Repository Backup
- Under Security Options select Run whether user is logged on or not and Run with highest privileges
- Select OK
Validation
We recommend creating a test task like the InfoBurst Repository Backup task described above. The purpose of the the test is to validate the PowerShell script and access rights of the Windows user scheduling the backup task. Set the test task trigger to One Time, let the scheduled test run, then validate the repository file was copied to the backup folder.