Veritas Velocity™ User's Guide
- Getting to know Velocity
- Setting up Velocity
- How to set up the Velocity Storage Server
- How to set up the Velocity Client
- Setting up the Velocity on-premises management server
- Upgrading Velocity
- Velocity Storage Server
- Users and roles
- Oracle database ingestion using Velocity
- How to use copy preparation to mask or sanitize sensitive data
- Oracle database ingestion using NetBackup CoPilot
- Microsoft SQL Server database ingestion using Velocity
- Database sources and copies
- About scheduling ingestions for a database source
- Retention periods for database sources and copies
- Sandboxes
- Database recovery
- Alerts and logs
- Managing the Velocity physical appliance
- Configuring network address settings on the Velocity physical appliance
- About WAN optimization on the Velocity physical appliance
- About the Veritas Remote Management Console on the Velocity physical appliance
- About Velocity physical appliance storage
- About users on the Velocity physical appliance
- About Velocity physical appliance checkpoints
- About factory reset on the Velocity physical appliance
- Configuring network address settings on the Velocity physical appliance
- Monitoring the Velocity physical appliance
- Velocity physical appliance security
- About Velocity physical appliance user account privileges
- About the Velocity physical appliance intrusion detection system
- About Velocity physical appliance operating system security
- Recommended IPMI settings on the Velocity physical appliance
- Best practices
- Troubleshooting
- Glossary
- Context-sensitive topics
- Section I. Velocity shell menu commands
- Introduction
- Appendix A. Main > Manage > Storage
- Appendix B. Main > Manage > Cloud
- Appendix C. Main > Manage > Software
- Appendix D. Main > Monitor
- Appendix E. Main > Network
- Appendix F. Main > Settings
- Appendix G. Main > Support
Adding a SQL Server database to ingest into Velocity
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.
Note:
FILESTREAM-enabled SQL Server databases are not supported.
Ensure that the items listed below are done before you add a database source:
The Velocity Client is configured on the host SQL Server.
The host SQL Server runs a supported configuration.
See the Velocity Software Compatibility List at the following URL:
To add a SQL Server database to ingest into Velocity
- From the Velocity Cloud Console, in the left pane, click Database Sources.
- On the Database Sources window, click +, and then click Add Database to Ingest.
- On the Choose Method dialog, select Ingest Microsoft SQL Server, and then click Next.
Note:
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.
- 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.
- Add the name of the instance, or leave the field blank to use the default instance.
- Add the name of the SQL Server database to add to Velocity.
- (Optional) Enter a meaningful name for the ingestion of the SQL Server database.
- (Optional) Enter a meaningful description for the ingestion of the SQL Server database.
- Click Next.
- (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.
Note:
You may have to upgrade your Velocity Storage Server to enable scheduling.
- (Optional) Select the amount of time you want to retain this database source and all of its subsequent copies.
Note:
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.
- 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:
Assign roles and permissions.
Create a sandbox.
View the database copies.
Set a retention date to delete expired database copies.