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
Editing default options for SQL Server database ingestion
To change the default options to customize a specific ingestion, edit the ingest_options.json
file.
For any changes to take effect, edit the ingest_options.json
file before you run the SQL Server database ingestion.
To edit the default options for SQL Server database ingestion
- Use your preferred text editor to open the
ingest_options.json
file, which is located at the root of the CIFS share on the Velocity Storage Server.Note:
Graphical editors are not supported.
- Edit any of the following options:
To change the name of the folder where the log files for the database ingestion are stored:
For the LogPath attribute, type the full name of the folder.
The default value is C:\\ProgramData\\Veritas\\Velocity\\Log
To change the default name of the log file that the ingestion creates under the default log path:
Change the value of the entry 'LogFileName'.
The default name of the log file is mssql_ingest.log.
To change the number of parallel data file copy operations that are used for data ingestion:
For the 'Parallelism' attribute, change the value to a non-zero value such as 2, 6, or 8.
The default value is 4.
If you enter a value less than or equal to 0, then the result is that the default value of 4 is used.
Warning:
The performance of data ingestion is affected when you change the number of parallel data file copy operations. You should balance using the processor for optimal data ingestion with the adverse effects of using system resources in your environment.
- Save the
ingest_options.json
file.