System Requirements

This section lists system requirements for Veeam Explorer for Microsoft SQL Server.

Component

Requirement

Microsoft SQL Server

Veeam Explorer for Microsoft SQL Server supports restore of the following Microsoft SQL Server versions:

  • Microsoft SQL Server 2022 (only for Windows)
  • Microsoft SQL Server 2019 (only for Windows)
  • Microsoft SQL Server 2017 (only for Windows)
  • Microsoft SQL Server 2016 SP2
  • Microsoft SQL Server 2014 SP3
  • Microsoft SQL Server 2012 SP4
  • Microsoft SQL Server 2008 R2 SP3
  • Microsoft SQL Server 2008 SP4

All editions of Microsoft SQL Server except LocalDB are supported.

The database whose logs you want to back up must use the Full or Bulk-logged recovery model. In this case, all changes of the Microsoft SQL Server state will be written to transaction logs, and you will be able to replay transaction logs to restore the Microsoft SQL Server. You can use the Microsoft SQL Server Management Studio to switch to one of these models. For more information, see Microsoft Docs.

Restore of Microsoft SQL Server data may require an available staging Microsoft SQL Server. To learn how to configure this server, see Configuring Staging SQL Server.

 

Note

AlwaysOn Availability Groups are supported for Microsoft SQL Server 2012 and later.

Consider the following:

  • By default, the AUTO_CLOSE option for Microsoft SQL Server databases is set to False.

If AUTO_CLOSE is enabled, your databases may be skipped from processing.

  • To restore database items from a Microsoft SQL Server that is running Microsoft Windows ReFS, the backup server or Veeam Backup & Replication console must be installed on a machine that runs Microsoft Windows Server 2012 or later.
  • To restore data from a server that is running Microsoft Windows ReFS 3.x, the backup server or Veeam Backup & Replication console must be installed on a machine that runs Microsoft Windows Server 2016.
  • Nodes participating in AlwaysOn Availability Groups are supported, but using Availability Group Listeners as staging servers is not recommended.

Staging SQL Server Requirements

Consider the following:

Note that databases that exceed 10 GB cannot be attached to the Microsoft SQL Server Express Edition due to Express Edition limitations. For more information, see the Editions and supported features of SQL Server 2022 Microsoft article.

  • A SQL Server included in Microsoft SQL Server Failover Cluster cannot be used as a staging system.
  • Configure domain trusts when planning to add databases to the Veeam Explorer for Microsoft SQL Server scope manually. For more information, see Configuring Staging SQL Server.