Back up the database

Note: Any transactions that are in progress when the backup is performed are rolled back if that backup is later restored.

To backup the database

1. In Microsoft SQL Server Management Studio, expand the AVEVA Historian, and then expand Databases.

2. Right-click the Runtime database, point to Tasks, and then click Back Up. The SQL Server Backup dialog box appears.

   

3. Click General.

4. In the Database box, select Runtime.

5. To use an existing backup device or file for the backup, select the destination in the Destination window and then click OK to begin the backup.

   Note: For details on a particular backup destination, select the destination in the list and then click Contents.

6. If you do not have a backup destination defined, click Add to add a new destination. The Select Backup Destination dialog box appears.

   

7. Select to back up to either a file or device.

   File name

   Type or browse to a path for the location of the backup file. Be sure that you have enough free disk space to store the backup.

   Backup device

   Select an existing backup device or select <New Backup Device>. The Backup Device Properties dialog box appears. In the File name box, type a name for the device. As you type the name, the path for the backup will be modified. Verify that the path for the backup is correct. When you are done, click OK to create the backup device.

8. Click OK to close the Select Backup Destination dialog box.

9. The newly-created backup device now appears in the Destination window of the SQL Server Backup dialog box. Select the new backup device.

10. Click OK to perform the backup.

You can configure various options for database backups, such as an expiration date for a backup. You can also schedule automatic backups.

For a complete description of database backup and restoration using SQL Server Management Studio, including scheduling recommendations and transaction log backup, see your SQL Server Management Studio documentation.