Restore to Another Server

You can restore Microsoft SQL Server databases from Veeam Plug-In backups to another server. To restore databases to another server, you must specify an authentication method to access the backup created for the original server. Veeam Plug-In for Microsoft SQL Server supports the following authentication methods to access backups:

• Using credentials of the account under which the backup was created. For more information, see Restore to Another Server Using Credentials.

This option is intended for backups created on the Microsoft SQL Server. To learn more, see Performing Backup.

• Using a recovery token. For more information, see Restore to Another Server Using Recovery Token.

This option is intended for backups created using an application backup policy configured in Veeam Backup & Replication.To use this option, a backup administrator must create a recovery token for the backup in Veeam Backup & Replication. To learn more, see Creating Recovery Token.

Consider the following:

• For restore to another server, you can use either backups or backup copies of Microsoft SQL Server databases.
• If you perform restore from a backup that was imported to Veeam Backup & Replication, Veeam Plug-In will automatically create the backup job in Veeam Backup & Replication.
• During the restore process, backup operations are not disabled on the Microsoft SQL Server.

Restore to Another Server Using Credentials

To restore a database to another server, you can specify credentials of a user account under which the backup was created. To do this, do the following:

1. Go to %PROGRAMFILES%\Veeam\Plugins\Microsoft SQL\ and run the following command:

2. Veeam Plug-In will prompt you to select an authentication method to access the backup. To access the backup using credentials of the account under which the backup was created, type 1:

3. Veeam Plug-In will prompt you to provide credentials of the user account that under which the backup was created. Enter a user name and password of the account:

After that, you gain access to the backups according to the credentials that you specified.

4. Perform database restore using one of 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.

Keep in mind that the account must either have the Veeam Backup Administrator, or both the Veeam Backup Operator and Veeam Restore Operator roles. You can also use the account under which the backup was created. For details on how to assign Veeam Backup & Replication roles, see Managing Users and Roles

Restore to Another Server Using Recovery Token

You can restore a database to another server using a recovery token generated in Veeam Backup & Replication and provided to you by a backup administrator. To do this, do the following:

1. Go to %PROGRAMFILES%\Veeam\Plugins\Microsoft SQL\ and run the following command:

2. Veeam Plug-In will prompt you to select an authentication method to access the backup. To access the backup using a recovery token, type 2:

3. Veeam Plug-In will display the fingerprint of the Veeam Backup & Replication server and prompt you to provide a recovery token:

After that, you gain access to the backups for which the recovery token was generated.

2. Perform database restore using one of 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.