Data Recovery

In the case of system failure, recovery procedures use previous backups to recreate a system that is as complete, accurate, and up to date as possible. You can also use backups to restore data that has been inadvertently deleted or modified.

When faced with the prospect of restoring data from backups, it is important to consider exactly what needs to be restored. The goal of effective data recovery is to restore the data that has been lost or destroyed without affecting files that are correct. It is extremely important to know and understand what files must be restored as a unit. For example, if you need to restore the database, then you must also restore the vault storage to ensure that pointers are correct.

The following procedure walks you through a complete database restore operation for SQL Server using the SQL Server Enterprise Manager. This procedure is provided as a guideline only. The procedure for your operation may differ based on the type of backup you are restoring from and your backup storage media type.

1. Start SQL Server Management Studio.
2. Expand the tree under Console Root until you get to the Databasesfolder.
3. Select the database that you want to restore.
4. Right click on the Database folder and navigate to RestoreDatabase…
5. Select the Device>Ellipse button>Add to select the backup file.
6. Click OK.
7. Make sure the correct database is selected in the Database field.
8. Click OK in the earlier dialog to return to the Restore dialog.
9. Click OK to begin the restore process.

In order to maintain system integrity and reliability, you should restore the vault storage files when the database is restored. Vault storage files are stored in a directory tree structure on a file server.

If you do not perform the restore operations in tandem, it is possible for a restored database to point to files that do not exist.

The Aras Innovator program files are stored in a directory tree structure on a web server. There are also DLL files that must be registered as part of the installation procedure. In the case of lost or damaged files, the program files can be restored from backup. However, if the server system files have also been lost, it may be necessary to re-install the application rather than simply restore the program files.

Aras Innovator configuration files are quite small and change infrequently. You can restore them from backup or recreate them from scratch with little effort.

If your server stops working properly, or if you want to revert your system to a previous state, you may want to completely restore from a system backup.