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

Creating a sandbox from a SQL Server database copy

Velocity Help

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.

Requirements

Ensure that the following prerequisites are set up before you create a sandbox:

To create a sandbox from a SQL Server database copy

  1. From the Velocity Console, in the left pane, click Sandboxes, and then on the Sandboxes dialog, click +.

  2. 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.

  3. Click Next.

  4. On the Configure Host dialog, specify the details of the host server that you want to host the sandbox:

  5. Click Next.

  6. 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.