/
MS-SQL Target Management

MS-SQL Target Management

Owned by Michael Litner
Last updated: May 14, 2025

General

A target host is a server that hosts the target databases - VDB’s. The target includes definitions of DB Homes - which are the SQL Server instances that are running on the target hosts and are used to run VDBs.

Targets management

  1. On the navigation bar, click Targets.
    The Target Hosts view is displayed, listing all target hosts that have been added to the system

    image-20250505-083922.png

 

You can quickly locate a target host by typing its letters on the Search bar. The list updates promptly.

Target host

Add a target host

To add a target host, see Install target agent

The target host maybe Windows only.

In case FILESTREAM data exists on the customer database - configure the MS-SQL instance as described here.

Modify, see details or delete a target host

To modify, see details or delete a target host, see Manage target agent

Target DB Home

Add a DB Home

  1. On the navigation bar, click Targets.

    image-20250505-084145.png

  2. Select the required agent

  3. Click the (+) sign in the right panel

  4. Select a DB type.

    image-20250505-084226.png

  5. Enter a name for the DB Home and an optional description

    image-20250505-084254.png

Name - name of the DB Home. Used only inside Accelario
Description - an optional description
Target Host - a target host that was installed earlier. Should be Windows server only

  1. The application runs an automatic discovery of all running MSSQL instances and presents them in a list.

  2. Enter details

    image-20250505-084434.png

    Instance name - choose from the list
    VDB User - enter a MSSQL login that will be created in all the future VDB’s
    VDB Password - enter a password for the above user

  3. Click Add to create the DB Home

Modify a DB Home

  1. On the navigation bar, click Targets.

  2. Select the required agent

  3. Select the required DB Home

  4. Click Modify DB Home.

    image-20250505-084720.png

  5. The Modify DB Home window appears. Modify the DB Home details as required. Same parameters as in adding DB Home, but the “Target Host” and “Instance name” cannot be changed.

    image-20250505-084823.png
    image-20250505-084814.png

  6. To save your changes, click Modify.

See information about a DB Home

  1. On the navigation bar, click Targets.

  2. Select the required agent

  3. Select the required DB Home

  4. Click DB Home info.

    image-20250505-085308.png
    The Info window appears.
    image-20250505-085225.png

  5. To return to the main Target Management work area, click Close.

Delete a DB Home

  1. On the navigation bar, click Targets.

  2. Select the required agent

  3. Select the required DB Home

  4. Click Remove DB Home.

    image-20250505-085417.png

  5. Click Remove to confirm the deletion or Cancel to exit without deleting the DB Home.

    image-20250505-085448.png

After the DB Home is removed, the following message appears: DB Home has been removed.