The Databases tab of the Restore wizard allows you to specify the databases you want to restore and the general location of the corresponding archive files. You can select:
- Repository - use this option when the backup files reside in your repository. Choose the SQL Server where the database(s) to be restored were backed up, then select the databases you want to restore.
- File System - use this option when the archive file was written to the local File System. Type the path from the network share or local drive and click ADD. This path must be accessible by the Backup Agent installed on the Agent Computer.
- Target Server - use this option when a network share is available on a remote file system (Target Server). Type the respective path and click ADD.
- Tivoli Storage Manager - use this option when the backup was performed using TSM. Specify the TSM Client Option File, Node name and password, Server address and port, and Path. When restoring from a TSM Server, browse for the correct database archive. You can change the TSM connections settings to override the values set in the client options file.
- Amazon S3 Cloud - select the location of your cloud storage where the respective backup files are located. You have to specify the Bucket Name, Secret Key, Access Key, and Region. For more information, go to Cloud Settings. Click Load Bucket and Load Backups to access your files in your cloud storage account. Then select the files and/or databases you want to restore.
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >