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, 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, and Path. When restoring from a TSM Server, browse for the correct database archive. Specify the High and Low Level archive files. You can change select the TSM connections settings to override the values set in the client options file.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 Amazon S3 Cloud - select the location of your cloud storage where the respective backup files are located. You have to specify the Bucket Azure Storage Account Name, Secret Key, Access Key, and RegionAzure Access Key, Sector Type, Authentication Method, Container Name, and Subfolder(s) (optional). For more information, go to Cloud Azure Settings. Click Load BucketYou can also, click Load Files and Load BackupsDatabases 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 > >
...
Once you select databases for your restore, click NEXT to select Backup Sets.
...