Database backup and restore for the G DATA Management Server

Further information on this file can also be found under the link Create database and assign to the G DATA Management Server.

GData.Business.Server.Config.exe is located in the G DATA Management Server installation folder, usually in

The user interface displays various parameters for the SQL Server installation. Clicking on Validate verifies that the database can be opened successfully.

Database backups can be created using the Backup function. No folder needs to be specified. If you do not enter anything, the file is stored in the backup directory of the SQL Server instance used and the database currently in use is backed up (e.g. C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Backup\GDataAntiVirusMMS_20210812160952.bak).

However, any folder on the computer on which the database is also installed can also be selected. If a local database server was defined, this can be a local folder. If an external SQL server was defined, a UNC path must be entered, e.g. \Backupserver\C$\Backups. Using the icon on the right-hand side, a folder can also be selected via a tree structure.

For the restore, the folder where the backup file is located is entered as the file path. If a different file name is entered, a new database is created with the backed up contents.

The account of the SQL Server service requires write permissions (for the backup) and read permissions (to restore a backup) for the respective folder. Please note that this account is not necessarily the account entered in this tool.

GData.Business.Server.Cli.exe, a command line application also found in the G DATA Management Server installation directory, can be used to perform database backups automatically. To ensure that the database is backed up regularly, a task can be added to the Windows task scheduler (Start > Run > taskschd.msc). Be sure to check the box "Run independently of user login", otherwise the backup tool will expect user input.

As with all backup-specific tasks, it must be checked whether the configured task was successfully executed and a backup was actually created at the desired storage location. No restore can be started via this application; if necessary, perform the restore as described in point 1.

If a backup folder was previously selected via GData.Business.Server.Config.exe, this will be used if no parameter was set. Likewise, the server instance, database name, user name and password are taken from the existing GData.Business.Server.Config.exe configuration. The account belonging to the SQL Server service must have the appropriate write permissions for the backup folder. This is not necessarily the account specified with the --username or --password parameters.

f it is necessary to migrate a database from an older G DATA Management Server version to a newer version, the best option is to use a copy of the original database files. The original files should also be used when migrating to another server (for step-by-step instructions, see Moving the G DATA Management Server to another computer).

The necessary files can be found in the Microsoft database directory.