Install the Backup and DR Service agent on the database hosts.
Make sure the database permissions are set correctly.
SQL database discovery considerations
backup/recovery appliances support Microsoft SQL Server on Microsoft Windows
server.
Discovery relies on SQL VSS writer. For the discovery to work correctly, SQL
VSS writer must be installed and running on the host.
Appliances can manage Microsoft SQL Servers, SQL instances,
consistency groups of SQL Server databases, and SQL availability groups.
For a SQL failover appliance, the discovery needs to be run on
either the active node—or node IP—or appliance node—or
appliance IP. Otherwise, clustered databases aren't discovered.
Add the host
Add the host to the management console. If the host has already been added, then
edit the host and make sure to set all the configurations correctly.
Click Manage>Hosts, then click + Add Host.
On the Add Host page, complete the following:
Name: Provide the database server name.
IP Address: Provide the database server IP and click the
plus sign (+).
Appliances: Select the checkbox for the appliance.
Host Type: Make sure this is Generic.
Click Add at bottom right to add the host. The host is added.
Right-click the host and select Edit.
Leave the Staging Disk Format as Block.
Enter the username and password that you set up in
Application Discovery Credentials.
Select Save.
Discover SQL Server instances and databases
Use the following instructions to discover SQL Server instances and databases:
Select SQL Server on the Add Application page, then select the
SQL Server database host. If you have many hosts, you can use the
search feature or use the filter to see only hosts that are managed by
a specific backup/recovery appliance.
Select the host and click Next.
This runs the discovery on the SQL Server host and discovers all SQL Server
instances and databases running on it.
Find the discovered instances and databases in the App Manager
To find the newly-discovered database, go to the App Manager Applications
list. All applications known to the management console of all types are listed.
Use the Type application filter to show only SQL Server
database instances. The new SQL Server instances and databases appear in the
list as unmanaged—the shield icon.
This page is one in a series of pages specific to protecting and recovering
Microsoft SQL Server databases with Backup and DR Service.
You can find additional information at:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-03-05 UTC."],[[["Before protecting SQL Server databases, ensure your network configuration and firewall ports are reviewed, install the Backup and DR Service agent on database hosts, and verify database permissions."],["SQL Server discovery requires the SQL VSS writer to be installed and running, and it can manage SQL Servers, instances, consistency groups, and availability groups."],["To add a host, navigate to Manage \u003e Hosts, click \"+ Add Host,\" provide the database server details, select the appliance, set the host type to Generic, and then edit the host to configure the Staging Disk Format and application discovery credentials."],["Discover SQL Server instances and databases by selecting SQL Server in the App Manager, choosing the relevant host, which will then discover all SQL instances and databases."],["Newly discovered SQL Server instances and databases will be listed as unmanaged in the App Manager Applications list, and can be filtered by the Type filter."]]],[]]
