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
Creating a sandbox from a SQL Server database copy
You can create a sandbox whenever you want a different database copy, or when you want to refresh a database copy.
The database files for the database copy are stored on the Velocity Storage Server, on a CIFS share. When you specify a computer that is running SQL Server as the sandbox host, the sandbox is automatically created as a CIFS share on that computer. Then, the SQL Server software can access the database files in the CIFS share and create and start the database for the sandbox.
You are prompted to provide the following information:
The time and date of the database copy that you want to use in the sandbox.
The SQL Server host that you want to access the sandbox.
Optional configuration details for the sandbox.
Ensure that the following prerequisites are set up before you create a sandbox:
The Velocity Client is configured on the host server that runs SQL Server.
The host server that runs SQL Server is a supported configuration.
See the Velocity Software Compatibility List at the following URL:
To create a sandbox from a SQL Server database copy
- From the Velocity Cloud Console, in the left pane, click Sandboxes, and then on the Sandboxes dialog, click +.
- On the Choose Database dialog, do one of the following:
To get the latest database copy
Select a database.
To choose a specific date and time of a database copy
Select a database, click the down arrow, and then select a date and time from the calendar.
- Click Next.
- On the Configure Host dialog, specify the details of the host server that you want to host the sandbox:
Sandbox Name
Type the name that you want to use for the sandbox.
Description
Type a description of the sandbox that will help you remember it or that is meaningful.
Host
Enter the hostname or IP address of the host SQL Server server on which you want to create a SQL instance for the sandbox.
Automatically start the database
This check box is selected by default to enable Velocity to start the database for this sandbox automatically after the sandbox is created.
Clear this check box if you do not want Velocity to start the database automatically after the sandbox is created. If you clear this check box, the sandbox is created, so you can perform a manual operation, recover data, or manipulate the data. You can choose to start the database manually at any time.
Instance Name
Enter the name of an existing SQL Server instance that you want to use for the database copy in the sandbox. You can leave this field blank to use the default name.
This field is disabled if you clear the Automatically start the database check box.
Database Name
Enter the database name that you want to use for the database copy in the sandbox. You can leave this field blank to use the default name of the ingested SQL Server database.
This field is disabled if you clear the Automatically start the database instance check box.
- Click Next.
- On the Review Settings dialog, ensure that your selections are correct, and then click Create.
After the sandbox is successfully created, you can use the database copy from your sandbox.