Restoring Microsoft SQL Server Databases

You can restore a Microsoft SQL Server database by following one of the following scenarios:

• Restore to the original location — to restore a Microsoft SQL Server database to the original location with the same settings.
• Restore with custom settings — restore a Microsoft SQL Server database to a new location, or to any location but with different settings.

Before You Begin

Before you restore application items, consider the following prerequisites:

• Application item restore is available in the Enterprise and Enterprise Plus editions of Veeam Backup & Replication.
• Enterprise Manager does not support application item restore from storage snapshots.
• Enterprise Manager users can restore items to the original location or a new location within the restore scope. Users must also have sufficient permissions to restore application items. Users with the Portal Administrator role have no limitations. For more information, see Configuring Accounts and Roles.

• For details on supported Microsoft SQL Server versions, see the Platform Support section of the Veeam Backup & Replication User Guide.

• When you restore application items with Enterprise Manager, restore limitations listed in the Considerations and Limitations section of the Veeam Explorers User Guide are also applied.