Searching...
SmallMediumLarge
Home Print Show Topic URL Previous Next

Adding a SQL Server database to ingest into Velocity

Velocity Help

To add a SQL Server database to ingest into Velocity, you specify information to identify the database. Then, you can start the ingestion immediately, or you can save the information and run the ingestion later. After databases are ingested, users can create sandboxes to access the database copies that they select.

FILESTREAM-enabled SQL Server databases are not supported.

Requirements

Ensure that the items listed below are done before you add a database source:

To add a SQL Server database to ingest into Velocity

  1. From the Velocity Console, in the left pane, click Database Sources.

  2. On the Database Sources window, click +, and then click Add Database to Ingest.

  3. On the Choose Method dialog, select Ingest Microsoft SQL Server, and then click Next.

    The default method to ingest the database source into Velocity is Use Velocity. Using a NetBackup policy to ingest a SQL Server database is not supported.

  4. On the Add Database dialog, enter the hostname or IP address of the computer that is running the SQL Server database that you want to add to Velocity.

  5. Add the name of the instance, or leave the field blank to use the default instance.

  6. Add the name of the SQL Server database to add to Velocity.

  7. (Optional) Enter a meaningful name for the ingestion of the SQL Server database.

  8. (Optional) Enter a meaningful description for the ingestion of the SQL Server database.

  9. Click Next.

  10. (Optional) To create a recurring schedule for the ingestion, configure the scheduling options, and then click Next.

    If you do not want to create a recurring schedule, click Skip.

  11. (Optional) Select the amount of time you want to retain this database source and all of its subsequent copies.

    After the retention period ends, this database source and all of its copies are removed from the Velocity Storage Server.

    If you want to save this database source and its subsequent copies indefinitely, click Skip.

  12. Do one of the following:

    To save the database information that you added, and then return to the Database Sources window without starting the ingestion:

    Click Save.

    You can run the ingestion any time after you have saved the database information.

    To save the database information that you added and start the ingestion now:

    Click Ingest.

    After the database is successfully ingested, you can do any of the following: