COMSOL 6.2 - Backup and Restore of a Model Manager Server Database

Backup and Restore of a Model Manager Server Database

You should configure backup of your Model Manager server database to protect from data loss in case of, for example, a server disk crash. Backup for a Model Manager server database using Managed Server Components can be configured from the Model Manager server web interface. Backup for a database using external components needs to be configured outside of the Model Manager server.


	Installation Planning

Backup of a Model Manager Server Database

Backup for a Model Manager server database involves configuring separate backups for its SQL database and resources directory. Its search indexes do not require backup.

See Backup of a Managed SQL Database Server and Backup of a Managed Resources Directory for the backup of Managed Server Components.

See External SQL Databases and External Resources Directories for the backup of custom server components.

Restore of a Model Manager Server Database

The steps required to restore a Model Manager server database from backup depend on how much has been lost in terms of configuration.

If the Model Manager server Preference Directory is missing, and there is no backup of that directory available, you will first need to recreate the configuration for the Model Manager server database. For Databases with Managed Server Components, begin by recreating the configuration of each managed server component:

•

Adding Managed SQL Database Servers

•

Adding Managed Resources Directories

•

Adding Managed Search Index Servers

Remember to specify the path for the backup root directory of the managed SQL database server, as well as for the backup directory of the managed resources directory. If you set the for restoring to for the managed SQL database server, and its data directory is missing on disk, the data directory will be automatically restored from backup when the server starts. Similarly, if the for restoring is set to , a managed resources directory is automatically restored if the directory is missing on disk.

Follow the steps in Adding Databases to recreate a configuration for the Model Manager server database — optionally replacing managed server components with external server components.

When a configuration for the Model Manager server database is available (for example, after recreating it):

If currently activated, deactivate the Model Manager server database — see The Database Configuration Page for instructions.

Restore the SQL database:

For an external SQL database server, use the restore functionality specific to the platform.

For a managed SQL database server, click the button on the page unless a restore has already been triggered automatically. Wait until the restore finishes. See also Restore of a Managed SQL Database Server.

Restore the resources directory:

For an external resources directory, copy files from the backup directory to their corresponding location in the resources directory — optionally skipping files already present in the resources directory.

For a managed resources directory, click the button on the page unless a restore will trigger automatically. The restore will begin once the database is activated again; see below. See also Restore of a Managed Resources Directory.

Restore the search indexes:

For an external search index server, recreate the search indexes used by the Model Manager server database or, if you have one available, restore the search index server from backup.

For a managed search index server, follow the steps in Restore of a Managed Search Index Server.

Activate the database if not already activated by a previous step.

At this point, if the Model Manager server database uses a managed resources directory, all missing files will be restored from the backup directory to the data directory. All search indexes will also be populated with search data loaded from the SQL database as needed. The time for both of these steps to complete depends on the size of the database.


	When the Model Manager server database has been activated, it is possible to connect to the database from COMSOL Multiphysics. Search results may be incomplete, however, until all search indexes have been repopulated with search data. Some simulation models and auxiliary data files may also fail to load if they depend on data in the resources directory that have yet to be copied from the backup directory by the ongoing restore.