DataSight Administrator provides you with a simple maintenance interface to perform backups of your databases.

These maintenance features are a subset of the various built-in functions of Microsoft SQL server, and particularly recommended for users that may be DataSight database administrators but not network System Administrators.

Open the Database Maintenance window from the DataSight Administrator Ribbon

• Click Database Maintenance in the Database group of the DataSight Administrator Ribbon. The Database Maintenance form appears in the Main panel with several function tabs.

Backup a Database

Database backups ensure you will have a copy of your database for archival and disaster recovery purposes.

1. Click Backup in the Database Maintenance window.
2. Choose your DataSight database to backup by selecting the Database name from the list of databases.
3. Enter a Backup Name. You should choose a name that is informative and may include details such as the database name, type of backup and time of backup.
4. Enter a Backup Description. This information can be viewed during a restore process.
5. Select the Backup Type. You can perform either:
   1. A full backup of your database (Database complete).
   2. A differential backup which contains changed information since last full backup (Database differential).
   3. A Transaction Log backup, which provides a backup for only the transactions since last full backup.
6. Enter File name and location of your backup destination. To backup to a device, specify the complete destination path.
7. You can elect to Append or Overwrite existing media. You can append your backup to a previously created backup file or you can overwrite your backups into the file you used for previous backups to prevent expansion of the backup file.
8. You can select the Verify backup on completion
9. Click Backup.