Setting up automatic backup (use case)
You can set up PANTHEON to automatically create a database backup to the cloud. The easiest way to do this is to create a new user who needs to be set as the owner of the database and have the backup authorization. For more information on how to add a new user, see the chapter Adding and deleting users.
This chapter contains a use case for setting up automatic backup.
 |
CASE SUMMARY
The person responsible wants to set up a task that will automatically start backing up the desired database to the cloud. This is done as follows:
- Creating a new shortcut to the PANTHEON program
- Setting parameters for automatic task execution
- Setting up the task autorun
|
1. Creating a new shortcut to the PANTHEON program
The person responsible creates a new shortcut to the PANTHEON program.
First, the person responsible opens the location of the program on the disk. This is done by right-clicking the PANTHEON start icon and selecting Properties from the list.
When the properties window opens, the person responsible clicks the Open File Location button.
This opens the folder containing the program files.
The person responsible right-clicks the Pantheon.exe file and selects Create shortcut.
A shortcut to the program is created in the same folder, which the person responsible renames to 'Pantheon - Backup'. The shortcut can be moved it to any desired location.
2. Setting parameters for automatic task execution
Next, the person responsible opens the properties of the newly created shortcut by right-clicking the icon and selecting Properties.
 |
WARNING
To set up task autorun, you need to set the correct parameters. For the list of parameters, see the chapter Automatic Backup.
|
The shortcut properties window opens. In the field Target, the person responsible enters the necessary parameters: '/L=AD: /BCKP:DB=myDatabase /BCKP:FULL /BCKP:CLOUD'
These parameters define the information about the user logging in to the program (backup-only user), the database to be backed up, the type and the target of the backup.
In this case, the full string in the field is: 'C:\Datalab\SIGIL\si\Pantheon.exe /L=AD: /BCKP:DB=EU_TECTA /BCKP:FULL /BCKP:CLOUD'
The person responsible saves the change by clicking the Apply button and then closing the window by clicking the OK button.
|
WARNING
Running this shortcut starts the automatic backup of the database to the cloud. It is recommended that you prevent other users from accessing the shortcut.
|
3. Setting up the task autorun
Now, the person responsible wants to set the automatic backup to take place every weekend at 17:00. This is done using the Windows tool Task Scheduler.
In the search box on the Windows desktop, the person responsible enters 'task scheduler and clicks the Run as administrator button.
This opens a new window Task Scheduler.
On the right side, the person responsible clicks the Create Basic Task... button.
This opens the Create Basic Task Wizard.
In the first window, in the Name field, the person responsible enters the name 'PANTHEON AutoBckp'.
In the Description field, the person responsible enters a description of the task if desired.
The person responsible continues by clicking the Next button.
On the Trigger panel, the person responsible selects the Weekly time interval.
The person responsible continues by clicking the Next button.
On the Weekly panel, the person responsible enters the date of the upcoming Friday 16.02.2024 and the time 17:00:00 in the Start field.
Then, the person responsible checks the Friday checkbox to set the task to repeat every Friday.
The person responsible continues by clicking the Next button.
On the Action panel, the person responsible selects the action to be performed by the task and checks the Start a program checkbox to indicate that a program will be started.
The person responsible continues by clicking the Next button.
In the Program/script field on the Start a Program panel, the person responsible selects the backup shortcut using the Windows Explorer, which opens by clicking on the Browse... button.
In the Add arguments (optional): field, re-enter the parameters - ' /L=AD: /BCKP:DB=SI_TECTA /BCKP:FULL /BCKP:CLOUD'. This step is not strictly necessary, because they are already entered in the shortcut.
The person responsible continues by clicking the Next button.
On the Finish panel, the person responsible checks whether the data is correct and confirms the entry by clicking the Finish button.
Automatic backup to the cloud has been set up successfully.
|
WARNING
All tasks can be added, edited or deleted at any time using the Task Scheduler tool. For more information about the tool, see Microsoft pages for developers.
|