Create a Backup

Backup Method 1: Direct via SQL Server (Default)

If the option 'Use New Method (no release, but extended rights required)' is selected in the settings of the waveware server, the backup is done without the Exchange directory/release directly via the SQL Server. This option is automatically selected after an update from an earlier version (10.150, 11.160 etc.).

Moreover, the setup or the internal flow of the backup depends on whether the waveware server and the SQL server are executed on the same device or the waveware server reaches the SQL server via the network. The permissions/roles in the SQL server needed during a waveware backup, differ based on the action to be used:

You can get general information on permissions on the SQL server under 'Database: Permissions'. Consider the following hints on the setup during the creation as well as a later restore, which gives a scenario that is appropriate for your installation.

Backup Method 2: Exchange Directory

If the option 'Use Old Method (Exchange directory required)' has been selected in the settings of the waveware server, a folder must be defined directly after the selection of the option, to which the access for the waveware server and the SQL server must be ensured in equal measure.

This directory is used to record the backup created by SQL Server (a '.bak' file) and forward it to the user of the DataManagement via the waveware server. The user of the DataManagement itself does not need any rights to this temporary directory. This directory is used to record the backup created by SQL Server (a '.bak' file) and forward it to the user of the DataManagement via the waveware server. The user of the DataManagement itself does not need any rights to this temporary directory.

Both paths must lead to a single folder, each from the point of view of each server. Keep in mind that both servers may be running with the Windows system user account and the user rights of the temporary directory may need to be adjusted.

If path data is missing in this setting, you get a message when creating a backup:

Automatic Backups  

Backups can be started when the data world (install ID) is active. An automatic backup must be performed using Windows PowerShell, which uses a script to load the necessary resources from waveware, log on to the waveware server and create the backup.

Create a PowerShell script in advance, which you save with the file extension ".ps1". The script could be structured as follows:

# Variablen
$installId = "waveware"
$server = "localhost"
0password = "SicheresPasswort"
$user = "Administrator"
$outputPath = "C:\Backups\"
    
# Angaben fuer die Anmeldung am DataManagement
$securePassword = ConvertTo-SecureString $password -AsPlainText -Force
$Cred = New-Object System.Management.Automation.PSCredential ($user, $securePassword)
    
# waveware Modul importieren
Import-Module "C:\Programme\LoyHutz\DataManagement\Powershell\wavewareDatamanagementModule.psd1"
   
# Erstellen des Backups
Create-WaveBackup -Server $server -DatamanagementCredential $Cred -InstallId $installId -OutputDirectory $outputPath​​

After you have stored the script, the setup could be done via the Microsoft Windows task scheduler, e.g. be carried out as follows:

1. Start the Task Scheduler by opening the control panel ("Management / Task Scheduler") or enter "Taskschd.msc" for the input request.
2. Create a new task. For this, click on the menu item 'Action' and 'Create task...' to deposit the task in the root depository of the task scheduler. Alternatively, you can create a new list and deposit the task there.
3. Give a name for the task on the register card 'General' in the opened dialog box, e.g. "waveware Backup" and define the security options.
   
   If the backup is to be run when the given user is not logged in, activate the option 'Run independently from the user login'. In this case, you will have to enter the password of the selected user upon closing the dialog box.
4. Click in the register 'Trigger' on the button 'New…'. Select 'According to a time plan' for 'Start task' in the opened dialog box. Advanced settings for the interval can be made after that. A weekly interval, executed on a weekend, for instance, is usually the best option.
5. In the 'Actions' tab, enter the path to PowerShell with the required "-command" parameter. Click the 'New' button and select the 'Start program' action in the dialog. In the 'Program/Script' field, enter the full path to PowerShell.exe (by default: "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe").
   In the 'Add arguments (optional)' field you must now enter the "-command" parameter followed by the path of the previously created script.

   -command "C:\Backups waveware\Script.ps1"

   Read more about the parameters in 'Recalling command lines'.
   Note that the previously logged user (3.) has enough permission for executing the DataManagementCMD.exe and for access to the output list of the backup.
6. You can define exceptions or advances properties on the register cards 'Terms' and 'Settings' which are not treated in further details here.
7. Save the task by clicking on the 'OK' button.

To try the created task, right-click on the entry and select 'Run'.

The status is displayed in a PowerShell window, which creates the backup and saves it in the output directory. More information on using PowerShell under: 'Command Line Call'.