Backup

In this chapter we are going to check options backup and restore database.

1. Backup

Database backup is the process of backing up the operational state, architecture, and stored data of database software. It enables the creation of a copy of a database in case the primary database crashes, is corrupted or is lost. The database backup can be stored locally, on a backup server or even in the "Cloud". Database backup is also created/performed to ensure a company’s compliance with business regulations and to maintain and ensure access to critical/essential business data in case of a disaster or technical outage.

Existing Backup	You can specify the path to the directory where you store your data in the menu Administration Panel | Upgrade/About | Upgrade. It is a LOCAL PATH on the server. Enter it as a local path on the server (e.g. C:\MSSQL\BACKUP, where C:\MSSQL represents a server directory) or by using the UNC annotation if a network share location is specified (e.g. \\SERVERNAME\BACKUP).
Name	Name of backup (database or programs).
User	Username who created a backup.
Date	Date when backup was created.
Size in KB	Size of backup in KB.
Location - Local backup	Backups are stored on local directory on a server or network server.
Location - Cloud backup	Backups are stored on a cloud server. See start parameters for backup to cloud.
	In order to use Backup to Cloud functionality a VAT No. for Subject that is set as This Company, must be entered. Backup to Cloud functionality is awailable only for non-HOST users. If there is no subscription for "Cloud backup" a message will appear when trying to backup a database to Cloud and a form for subscriptions will open.
Backup Database	A list of all databases on a server is opened.
Backup Executables	Executables are saved (e.g. Pantheon.exe, PantheonRT.exe, PaUpgrade.exe)
Password	Set a password with at least 8 characters for creating a backup. You must use the same password when restoring a database.
Save	Backup the selected database(s).
Close	Close the list of all databases on a server.
Autodoctoring	The Autodoctoring form is opened.
Restore Database	Restore a database backup. Or selecting Restore Data from right click menu.
Restore executables	Restore a backup of an executable.

Deleting a database can be done by selecting Delete option from a mouse right click menu. Select multiple databases by using Windows options of combination SHIFT or CTRL and selecting multiple database and then select Delete from mouse right click menu.

2. Restore

Restoring database:

On the SQL platform, the logical names, physical names and location of the database must be specified for the restoration of the database. Logical program names are read from .bak files and entered into fields. If you enter the physical names that already exist on a location, restoring is prevented.

Restore of Pantheon database is only possible for backups that were made via Pantheon .

If the backup was password-protected, the same password must be entered at the time of restoration. We advise you to save the password to an extra secure location. Only by using the correct password will you be able to restore the locked archive!

Operations that have access also on other databases on the same SQL server can be prevented with authorizations. Such user is prevented to access any linked databases or current database through Pantheon. Authorization is located:  Datalab Applications - Datalab PANTHEON - Settings - Program - Administration Panel - Database - Access to Other Databases