With 1-Click Restore, Veeam Explorer allows you to quickly restore one or several databases to the original location (that is, the original SQL server instance hosting the database(s)). You can restore selected database(s) to the current state, or to the certain point in time - for that, make sure the SQL Server backup job was set up properly (see Required Microsoft SQL Server Backup Job Settings ) and completed successfully.
Restore process will be performed with the following settings:
- Database(s) will be restored to the original VM (files will be copied to the original location and then attached to the original SQL Server instance). AlwaysOn availability groups will be restored in accordance with the source (backup) settings.
- User credentials for carrying out the restore procedure (using Windows authentication) will be picked as follows: firstly, Veeam Explorer will try to use the account which is currently logged in. If this account does not have sufficient rights to perform the restore procedure (for example, in case of imported backup), then it will use the account configured for guest access in the corresponding backup job; if this does not work either, user will be prompted to supply the necessary credentials. Remember that the account should have administrative rights on the target server. For detailed information on required permissions, see Required Permissions.
If database with the same name exists on target, it will be deleted and replaced by the database from the backup.
In This Section