The Databases section 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 backups from the following locations:
- 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. Use the Browse option to load the backup info of an specified file in your File System. 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 or click Browse to select the file from the file list.
- 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. If you have to specify TSM striped files, click Fetch Stripes to access them.
- 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 Amazon Settings. Click Load Bucket and Load Backups to access your files in your Cloud Storage Account. Select the files and/or databases you want to restore.
- Microsoft Azure Cloud - use this option to access your Microsoft Azure Cloud where the backup files are stored. You have to specify your Container Name, the Azure Storage Account Name, the Azure Access Key, and the Sector Type. For more information, go to Azure Settings. Click Load files and Load db to access your files in your Microsoft Azure Account. Then select the files and/or databases you want to restore.
Click NEXT to go to the Backup Sets section.