Performing Restore
You can restore Microsoft SQL Server databases from backups created with Veeam Plug-In. Veeam Plug-In supports restore of entire databases to the original Microsoft SQL Server machine or to another server.
You can restore a database to the same or different SQL instance. If you have backup of Microsoft SQL Server transaction logs, you can specify a point in time to which you want to restore the database. Otherwise, Veeam Plug-In will restore the database to the time when the restore point was created.
Important |
It is recommended to create a full backup immediately after you restore a database. All subsequent log or differential backups of the restored database will be based on this full backup. This action helps prevent potential data loss. |
Before you perform database restore, consider the following:
- The backup job that created the backup must be present in Veeam Backup & Replication.
- To restore to another server, you must perform the restore operation on the target server, where you want to place the new database backup.
- To restore to another server under another user account, you can use on of the following options:
- Use the user account that either has the Veeam Backup Administrator, or both the Veeam Backup Operator and Veeam Restore Operator roles.
- Use the recovery token generated on the Veeam Backup & Replication side.
To learn more about options to restore to another server, see Restore to Another Server.
To restore Microsoft SQL Server databases, you can use the following tools:
- The Restore Database wizard. For details, see Restore with Restore Database Wizard.
- The MSSQLRecoveryManager.exe command-line tool. For details, see Restore with Command-Line Interface.
- Veeam Explorer for Microsoft SQL Server. For details, see Restore with Veeam Explorer for Microsoft SQL Server.