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 Path. Use the Browse... option to find the correct database archive file. Specify the TSM Client Connection Settings. Click Change to override the values set in the client options file. Specify a different Node name and password, Server address, and port. Specify the High and Low Level archive files. You can select the checkbox to include inactive files. You can also, find archives.
- S3 Storage - use this option when the backup file is stored in Amazon S3 Cloud. You have to specify the Storage Type, Access Key, Secret Key, Region, Bucket Name, and Subfolder(s) (optional). For more information, go to Console Preferences and review the Amazon S3 Cloud and S3 Compatible Storage settings. You can also, 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.
- Microsoft Azure Cloud - use this option when the backup file is stored in the Microsoft Azure Cloud. You have to specify the Azure Storage Account Name, Azure Access Key, Sector Type, Authentication Method, Container Name, and Subfolder(s) (optional). For more information, go to Azure Settings. You can also, click Load Files and Load Databases to access your files in your cloud storage account. Then select the files and/or databases you want to restore.
Once you select databases for your restore, click NEXT to select Backup Sets.