Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Historian

Restore the database

  • Last UpdatedMar 04, 2025
  • 1 minute read

When you restore a database from backup, any information saved to the database since the backup was performed is overwritten with the restored information. All changes to the database since the backup are lost. Also, any transactions in progress when the backup was performed are rolled back.

To restore 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 Restore. The Restore Database dialog box appears.

    Set up restore instructions for the database

  3. Click General.

  4. In the Restore as database list, select the Runtime database.

  5. Select Database from the Restore options.

  6. In the First backup to restore list, select the desired backup.

  7. Click OK. The information is restored.

You can configure various options for database restoration. For more information on restoring from a backup using SQL Server Management Studio, see your SQL Server Management Studio documentation.

TitleResults for “How to create a CRG?”Also Available in