Restore Database

This process will restore a backup that has been saved to a location on the hard drive.

When this option is chosen, the connection dialog will be displayed. The SQL Server name/instance name will be displayed if it has previously been entered. The name of the server is required and it must be a valid server. Next takes you to the next step of the Restore Database process.

Connect Using - Select how you wish the database connection to be made.

• Windows Authentication - This is the default setting.
• SQL Server Authentication - if this option is selected, the user name and Password fields must be filled in.

Database - Select the database you would like to restore. This dialog will also display the last date and time a restore process was performed.

Next - Select Next to continue with the Restore process.

• Show only .bak files - VT backups have an extension of .bak. If this option is checked only files ending with this extension will be displayed.
• File Name - Browse to and select the VT backup file to be restored.
• Selected File - The location of the file will be displayed after it is selected.
• Next - when next is selected the restore process will begin.

All connections must be closed in order to restore a backup. This message will display if there are connections and services to be restored. If "Yes" is selected all services and applications will be closed.

There will be a warning that restoring a database will overwrite the existing database and gives the user to continue or not. Choosing "Yes" will continue the restore process.

Finished - Click this option to complete the restore process.

This message will display when the process is completed.